Data Assist Search showing results not in the recordset
I am having a strange thing happening were if I search for a particular word I get a result that is not in the recordset. If I do a blank search to show all the results it is correct and only shows me the correct records from the recordset. I can not work out why this is happening.
the recordset query is:
SELECT RecipeID, Title, Serves, Intro, WhatYouNeed, HereHow, CountAs, CatagoryID
WHERE FoodPlan = 1
I have attached the web page as well. I would be grateful for some help as it is really important that the results are accurate and are not returning results that are not from the recordset.
Many thanks as always