Link Query results back to a form?

[Eric]

Hi There!
I have an Access 2000 database with one table, one
query and one form. When I run the query I would like the
user to be able to click on the primary key of a record in
the query results and have the form with the same primary
key pop up. Is this possible? Any help would be greatly
appreciated. Thanks eric

 

[Jeff Boyce]

Eric

Consider another approach ...

If you put a combo box in the header of the form, use the query to populate
the combo box, you can filter the form to display the row that the user
selects in the combo box.

Good luck

Jeff Boyce
<Access MVP>