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

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.