Opening a form based on a query with VBA-set parameters

[dipique]

The problem is that setting the parameter for the query in this procedure has no effect on the query as the recordsource for the called form. It is not persistent between the two instances of the query. There is more than one way to filter the recordset for the called form. You can either use a combo or list box on your calling form to select the value you want to use for the filter and reference that form control in the query instead of the parameter currently in it. Or you can pass that value to the called form via OpenArgs and then, in the open event of the called form, rewrite the SQL in the query dynamically to use that OpenArgs value.

Thanks, I think I can use one of these methods to solve the problem. What you said made sense--that they are different instances of the query.

Much appreciated!

Dan