form and report sync on different data 1

[irethedo]

I have a form which contains fields of data and a button to print a report. The report uses a query but for some reason the data in the report does not match the data on the form as it is displaying a different record from the table than the one on the form.

Does the data on the form need to be added (like DoCmd.GoToRecord , , acNewRec) before I can display it in a report?

How can I fix this so that the data in the report matches what is on the form when I click the button?

Thanks

Jeff

 

[THWatson]

Jeff
Your DoCmd line would include a reference to the particular record you wish to print.

Something such as...
DoCmd.OpenReport YourReportName, acPreview, "", "[RecordID]=[Forms]![YourFormName]![RecordID]"

Tom