Open a Form to a specific record using a query

[Maleficent]

I'm trying to open a form at a specific record based on the results of a query.

i have the query set up to find the records based on 2 drop down lists on another form

the query runs correctly on its own

i have tried to add a macro to a button to open the form at the record identified by the drop downs, by typing the query name into the "Filter By" box. it just opens up a blank record in the form

if i run a macro to open the query it works perfectly. so the issue is with getting the form to open at the correct record.

any advice would be appreciated!

Thanks

 

[Ranman256]

The query would be behind the form.
The form show the results of the query. (Continuous)
The button on the header will open a form (to show detail) to that 1 record.....

Docmd.openForm "frmDetail",,,"[id]=" & me.txtID