open report of current form (record)?

[behedwin]

I have a form displaying one record from a query.
I use this form to view, edit and create new records for different tables.

Now i want to create a report of the recordset that i have opened in the form.
so i can press a button and open a form with the same information that i have open.

I guess i should create a query that only display the record of the currently open form

but how do i do this?
or is it an better way?

 

[ranman256]

yes, make a query to pull the data of the current record , (the ID key)
select * from table where [id]=forms!myForm!txtID

the report would be based on this query.
docmd.openreport "rMyReport"