[RESOLVED] Help with expressions [Forms]![Form46]![month]

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

I worked it out.. Hope this helps someone else.

Answer:

1. Like [Forms]![Form46]![month] is the modification to the query expression
2. Enter * in the combo or text box