arobinso,
Create a query with the info you need.
Create a form with the control source set to the query.
Choose command button on the "tool box" and place it on the form. Choose "form operation", "open form" pick the form you want to open and follow the rest of the prompts.
Jim