Update Form / Report

[billythedj66]

I have a Button (Print Report) on a Form (220 Form) that opens a specific record of a Report (220 Form - Payment 1) then prints the report, the problem I have is that if I enter or edit any of the fields on the Form, the changes aren't seen on the report, what am I missing, here's my code:


Private Sub Print Report_Click()

DoCmd.Save
DoCmd.OpenReport "220 Form - Payment 1", acViewNormal, , "[JobID]=[Forms]![220 Form]![JobID]"
DoCmd.Close acReport, "220 Form - Payment 1"


End Sub

PS: Happy Holidays!!!

 

[Norie]

Are the form/report based on the same query/table?

Try Me.Requery in your code to update the underlying source for the form.

 

[billythedj66]

Yes, both the Report and Form are from the same Table. I am trying to avoid going to next record, then previous record, before printing the report.

 

[Norie]

Billy

Have you tried Me.Requery? It would go right at the start of the code you posted.