Very much appreciated as this solves the problem. I still wonder why the problem occurs with Form Open only with the listbox is set to no multi select but I'll curb my curiosity and get on with the actual work!
Again, thanks very much.
ALthough I first found the problem I'll describe in a complex database, to troubleshoot (and try to confirm it was not a user problem) I then started a very simple DB with one form. Add a list box with three values entered directly ((All), (Non Blank), (Blank)). Set the multi-select option to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.