I have a form where users have to go through a lot of data. The data is being viewed in a list box. This is because they need to be able to select one of the items in the list. The list box will pick up filter criteria from text boxes on the form. Basically a user may want to use different criteria to do there search. At the moment I have got Date and Amount so for date I want to give the option where the user can leave the date blank or enter a date, and if the date is blank then no date filter should be applied.
*The following code is in access query builder, I had put this into the criteria section of the Builder.
Expand|Select|Wrap|Line Numbers
- iif(isnull(Forms!FrmFilter!tbDate),>#01/01/1900#,Forms!FrmFilter!tbDate)
Thanks in advance