Print Button on a Navigation Form

[sotssax]

I have a navigation form with an employee info form as one of the tabs. The Employee Info form has a combo box used as a record lookup. It also has a print button that will print the current record after looking it up. My problem is that the print button works just fine if the Employee Info from is opened directly but it will print the first record only if the form is open as part of the navigation form. Any ideas why this is happening?

By the way, I am now using Access 2010.

[rpeare]

Can you attach a sample of your database, just make a copy of your database and remove any privacy information. I suspect your report is set to use the current record as the data source for a report but if you don't have the form open it's just choosing the first but I wouldn't be able to tell you without a sample.

[sotssax]

I have not had time to make a sample, but here is the button event procedure. I'm not sure if this would help.

Private Sub printbtn_Click()
On Error GoTo Err_printbtn_Click

DoCmd.RunCommand acCmdSelectRecord
DoCmd.PrintOut acSelection
Exit_printbtn_Click:
Exit Sub
Err_printbtn_Click:
MsgBox Err.Description
Resume Exit_printbtn_Click

End Sub