Creating a Dynamic Query

[gdshih]

I am trying to create a query which will change depending on what is selected in a combo box. This is what I have been putting into the criteria but it doesn't seem to be working:

[Forms]![frmMainMenu]![cboDeptName]

Any help would be greatly appreciated, thanks!

[June7]

Why is not working - error message, wrong results, no results?

Is the combobox multi-column?

[gdshih]

I don't see any results. No, the combo box is not multi-column.

[pbaldy]

In regards to your PM, make sure you aren't using the .Text property of the combo, as it requires focus. What you posted should work. Is the form open at the time the query runs? Does the combo return the same value the query is looking for, as opposed to an ID instead of a name or something? Can you post the db here, or a representative sample?

[June7]

Are you viewing the results of the query in a form? Probably need to requery the form after combobox selection. In the AfterUpdate event of combobox, include code: Me.Requery. Is the query form a subform? Then: Me.subform.Requery

If you need more help, provide project for analysis.