Command Button to Print active record?

[sheyde]

I want the ability for my end user to find a specific record in form view - once record has been found - to click on a command button that prints the current record that is open. I have a specific report that I want to use - however, I keep coming up with the dialog box to ask - print what record. I want to eliminate that box. Any suggestions would be very helpfull

 

[Elana]

Look at the Northwind dbase for an example of that very thing. Go to the Orders form and the Print Invoice click event. They use a selection query to filter for the active record - it works great.