Access queries keep changing

  widdy 08:17 25 Sep 05

I have a database with just one table consisting of names addresses, phone nos etc, about 20 fields.
All queries work from a switchboard. if i look for a person by name my criteria is " Like [enter surname] & "*" " which allows me to look using just the first few letters. this works fine a few times then suddenly will start to go in a loop and ask me to enter surname again up to 3 times.
If i rewrite the criteria and save it, all is well to start and then it loops again.
Any thoughts

  widdy 08:03 26 Sep 05


This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017