Similar to Sorting question

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

I want to do the same thing as Josh does. I currently have
parameter queries, but if the user doesn't know, for
example, the manager's name, I would like to have a drop
down box that they could just click the desired name and
it would take them to all the records with that name in
them. Is that even possible?
 
Josh,

One way to accomplish this would be to build a form with a
command button to run your query and a combo box that
contain the manager's names from your table.

The value of the combo box would be passed to your query
on the criteria line for the manager's name field as shown
below:

=Forms!YourFormName!YourComboBoxName

The command button to run you query would have an On Click
event as shown below:

DoCmd.OpenQuery "YourQueryName", acViewNormal

This should solve your problem.

Regards,

ET Sherman
 
I want to do the same thing as Josh does. I currently have
parameter queries, but if the user doesn't know, for
example, the manager's name, I would like to have a drop
down box that they could just click the desired name and
it would take them to all the records with that name in
them. Is that even possible?
Click to expand...

See my reply in the other thread: possible, easy, and even standard!
 
Back
Top