Search results

Hi all, I am working on a multiple optional field search form, the query for which is created by a VBA setQry. I have very little experience with VBA as I am working with a Web Database which forces one to rely on Macros. The form and query are working great, except that in order to make one...

Perfect! Thanks very much :) I've had to use Tempvars for several tasks already, didn't even occur to me to use one here but your explanation is as useful as the code, so I'll know when I need them in future! :D

I am building my first web database (synced with sharepoint server) with limited experience of Access (have done some small non-web databases mainly for personal or self-teaching purposes). I have found the answers or at least clues to help solve many of the problems I've come across so far...