Data missing when printing a dirty record / form!!

[Oliver2003]

I have a form where data is entered and updated - on this form I have a cmb which prints a report for the current record using the docmd.openreport method.

The problem I am having is that when new data has been added to the form and the print button is clicked, the report will print off but not with any of the new data.

I am having to go to the pervious record and then back to the current record so that the data is saved and the report prints ok.

Is there a way to prevent this?

cheers.

 

[LittleSmudge]

Yes,

The reason is that the changes you've made are just to the form - You have not stored those changes back into the underlying table. When you run the report it looks at the table - not at the form ( The report is, after all bound to the table )

So what you need to do is add a line in the cmd button On_Click event , before the DoCmd.OpenReport that saves the changes on the form to the table.

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Will do fine.



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[Oliver2003]

Thank you very much LittleSmudge thats just what I wanted