Refresh form

[Annelie]

I have created a form from a query which tests for errors on imported
payroll data. When an errors shows, a command button opens the individual
employee record for changes. After the change is made, I would like to
refresh the form, which stayed open while its underlying data changed. I
tried a refresh button, but that does not work. How can I get the data to
correct without having close and reopen the form.

 

[Alfred]

Hi
Use Me.Requery
Alfred

 

[Annelie]

How and where do I do that??

Hi
Use Me.Requery
Alfred

 

[BP]

you could do that on a command button or after all the
changes are made on record exit

 

[Annelie]

That would not work because I need to view the change records to make sure
that the result is correct.