getting query value from a form, how?

[EssieP]

I've used the expression builder to get the value of a criterium from a form. The problem is that it always returns no records when I run the query via a report which is itself opened by a button on the form. there is a small amount of test data present.

If I open the report directly (with the form closed) then a dialog box appears where I can successfully type in the criteria, then the report shows the expected results.

So why doesn't my search form work?

Note: it's in Access 2000.

 

[pdx_man]

Change your Bound Column to 2, or get rid of the ID field and change the combo box to having only one column. Or change your query so the criteria is on the IDthings field. To illustrate what you are getting from the Combo Box, open up your form and select a value. Then go to your underlying query and put the criteria up in a blank column removing all criteria and run the query. You will see that you are getting the ID value, not the ThingName.

 

[EssieP]

erm, what's a "bound column"?

--------------
AH I get it !! The combo was returning a value that was hidden in the drop-down, the ID field.

 

[pdx_man]

Yup!