Search results

Perfect, thank you.

Sorry, no joy. All of the other filters work fine, it's just this All option that isn't. There is an All entry in the field it's looking in too so it isn't just evaluating the IIf as false all the time because it doesn't show that All. It's almost like it's looking for a * character rather...

Hi, I have a form with a list box that is filtered by the entry made into a combo box. It works fine except that I want an option which shows all records in the list box. I tried using the formula below in the query criteria for the list box but it returns no records when I select All in the...

Thanks That's done the trick. Thank you.

Hi, I am a relative amateur with access so you may find this a simple request but please bear with me if I say anything stupid. I have a database that was set up by someone who I can no longer contact who knows more about databases than I do. In it there is a form which displays results of a...