record updates after going to the next record

[AmyLynnHill]

I have a user interface form (frmCP)that a report is generated from(rptCP). the form has many option buttons that are option groups of yes or no, it also has text boxes and date fields. The form is attached to a table(tblCP).
When the user inputs the data, the report doesnt show the changes until they navigate to the next record at which time the data is written to the table.
Is there a way to have the data write to the table at the time the user inputs?
I tried using the ON DATA CHANGE event on the form..didnt work.
Any ideas?

 

[pbaldy]

You could put this right before running the report:

DoCmd.RunCommand acCmdSaveRecord

 

[AmyLynnHill]

WONDERFUL! it works like a charm!
Greatly appeciated.