I am working in access 2007. I have created a form with a button to bring the data from the record to a report that has been created.
I have put the code below. The problem I am having is that no matter what record I enter into the pop up box, it displays the FIRST record in the database in the report.
Thanks for the help.
Private Sub printlabelbutton_Click()
DoCmd.OpenReport "ShippinlabelRPT", acViewPreview, , "InternalRepair_ID=" & Me.InternalRepair_ID