I am using an unbound form to print specific information in a report. Each item is a dropdown list which is based on a table. However if a user does not wants to see all the items for a particular category then I want them to be able to use the asterick to do this which is set as the default value for each dropdown menu.
Currently this is done by :
A macro runs when button is pushed on form after.
Macro says OpenForm and the Where item is set to [item1]=[Forms]![DataCrit]![item1] And [item2]=[Forms]![DataCrit]![item2]......etc
Now this works if they select an item, but if they do not and the asterick remains then I get an empty record set. How can I get an option in each dropdown menu so that they can set it to All or use an asterick so it selects all the data for that particular criteria?
Currently this is done by :
A macro runs when button is pushed on form after.
Macro says OpenForm and the Where item is set to [item1]=[Forms]![DataCrit]![item1] And [item2]=[Forms]![DataCrit]![item2]......etc
Now this works if they select an item, but if they do not and the asterick remains then I get an empty record set. How can I get an option in each dropdown menu so that they can set it to All or use an asterick so it selects all the data for that particular criteria?