Pass a form value to query parameter
Posted on 2002-07-01
Have a combo box on an unbound form. The form name is Parameter and the combo box name is Trainer. The combo box is linked to a lookup query. I want the value in the combo box to pass to another, parameterized, query.
In the query design page of the parameterized query I have set the following criteria: [Forms]![Parameter]![Trainer]
When I run the query, if the Parameter form is not open, I get prompted for the parameter value and the query returns the correct records. However if I use the Parameter form it does not return any records.