find a variable?????

[authorsami]

Is there a way to find out what variable a combo box is sending to a query?

I have a combo box on a form that is used as the critera for a query. When I type in the query the criteria, the query works great.

When I use [forms]![frmPatByLocation]![Combo8] to put the criteria into the query I get nothing!!!!

I need help. Can any tell me a way to find the variable that the query is trying to use???

Sharon
sharon@comptutor.net

 

[Mile-O]

When I use [forms]![frmPatByLocation]![Combo8] to put the criteria into the query I get nothing!

You are not dealing with a variable (although you could argue that it was as you can change the value of a combo) but are referencing a combobox.

The value referenced by the line above is the value in Column(0) of the combobox.