Dynamically search multiple fields

[david.paton]

I can't get the modification search tool working posted by John Big Booty here https://access-programmers.co.uk/forums/showthread.php?t=188663.

It doesn't make sense as I have used it before, have looked at my previous dbs and my db looks exactly the same as the previous ones that work.

What have I left out or done wrong? I have attached my db.

Thanks

 

[MarkK]

Your QRY_SearchAll doesn't return any records even if you delete its WHERE clause, so even wide open with no constraints, it doesn't return any rows. There is not way, therefore, as you add constraints, that it will start to return rows.
hth
Mark

 

[david.paton]

That is what I was finding too, but I followed the instructions exactly and it still wouldn't work. Just thought someone else might see something that I am looking straight over.

 

[JHB]

..Just thought someone else might see something that I am looking straight over.

It's your data there has no context.
It table tblCarers, you've in CarersTownID = 4, but in table tblKSCarers you don't have a number 4 in KSCarersTownID.