Refresh control or form

[FJM]

I have a data entry form with several controls and at any point in the entry process, a report may be needed to be printed which shows the data which has been entered so far.


At the moment, for each seperate control I have the "me.refresh" event on After Update so this means that whatever control is being manipulated, it will always be updated and so appear on the report.
Is this the best method, or is there another way of making sure that once data has been entered it will always appear on the report instantly.

[TG_W]

Personally, I prefer the code below set in the After Update event of each text box/combo box/etc.

DoCmd.RunCommand acCmdSaveRecord

[FJM]

Is there any difference in the result between your code and the me.refresh ?

[TG_W]

The acCmdSaveRecord actually saves the record rather than just refresh the screen. It can replace the need for clicking the pencil in the Record Selector, thus making it removable if you do not need to delete records. It's just a more reliable way to ensure that the data is saved after updating an editable object on a form.

[FJM]

From a curiosity point of view, what would happen if I added the code in the AfterUpdate of the Form itself. Would that give a different result ?

[TG_W]

I'm not sure since I've never tested it. I just put it in whatever text boxes I make available for edit that should be saved immediately so there are no updates missed.

[FJM]

OK thanks. How do I mark this as SOLVED

[TG_W]

At the top of the thread, look under "Thread Tools".