Data not refreshing on form

[wbilbro]

When I do a DoCmd.Requery for my form, it behaves differently from clicking F9 to refresh the data with my changes.

I am trying to refresh multiple controls on a form before viewing the report. Can anybody please tell me why the DoCmd.Requery is not working and how I might fix this problem.
Thank you

 

[Rich]

Try Me.Refresh

 

[wbilbro]

Thanks!

 

[Keith Murdock]

I usually refresh or requery a form when the data has changed behind the scenes in the table underlying the form. Then "me.requery" or just "requery" usually works in a command button on the form.

But sometimes users will make changes in a form and print the report before changes have been updated in the table. So the report still sees the old values.

Requery won't work because it just tells the form to fill with data from the table and the updated values are not yet in the table.

So, you can paste this into your print button just before the print command and it will update the values in time to be seen in the report...

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70