Help with Expression [Forms]![Form46]![month]

[mshelley1]

Access 2000

I have an “unbound” form with a list box, a text box, and a combo box. The list box’s Row Source Type is a Query. The query’s criteria come from the textbox and a combo on the form. Once the information is entered into textbox and the combo box a macro is set to run on the combo box’s “On Change” event, which runs a Do Command Refresh Page. This expression [Forms]![Form46]![month] is an example of how I am setting the criteria in the query; which when I put the month “May” in the text box passes that information to the query’s design view “Month column. The combo also works the same way. What I need is to know what type of expression do I use so that I can use “All “ in the text box and combo box.

Thank You

Carbo

 

[jesusoneez]

OK, I think you're trying to do something that I've just figured out myself, or at least it'll point you in the right direction. If you're wanting all records when the combo box is blank for example you need something like;

[Forms]![Form46]![combobox] or like [Forms]![Form46]![combobox] is null

This returns all records if you don't select any search criteria. Hopefully you can use this for your situation (or something similar).