Ok, I am stuck again of course lol. I have my forms and reports working, however when I click on my button to load the report, the values of the fields from the form are updated to the report unless I save the record then go back to the record. I am trying to load all the values to the report from the form before saving the record.
I have tried to use the requery command on the main form to ensure all fields are updated before opening the report.
Example below is for the current button to load the Orders report, however no matter what combination I use, the report doesn't update with the values when it loads from the the click event.
Private Sub btnPrintOrder_Click()
DoCmd.OpenReport "Orders", acPreview, , "[JobID]=" & Me.JobID
Thanks for any help