Pick list from query?

[g-richardson]

I'm trying to have a query open via choice of a pick item instead of a parameter. Instead of having to type a name exactly as appears in the table, I want the query to give me a choice. This query will be the underlying datasource for a form.

I want the form to open based on the choice from the query. Can I get this done?

Thanks,

 

[Mile-O]

I think there's a fundamental misunderstanding here.

Base your form upon a query. If you need the query to list specific records based on criteria - use a listbox on another form listing the potential criteria.