Originally Posted by
Access_Novice
...I advanced to the next record, then went back to see if my new record showed up. And it did show up...
...Was this an example of requerying or refreshing the record since the new record showed up...
Neither! When you add a New Record, and the Record is saved, such as by moving to another Record, that New Record is there, on your copy of the Form!
Is is not, however, 'there,' on the same Form that is currently opened by another user! In a multi-user environment, Refreshing their copy of the Form won't make it display, either. It will only display for other users by their Forms being Requeried.
The Refresh Method is really intended to be used, in multi-user environments, to show UserA any edits made to existing Records by other users. And by 'existing Records, I mean Records that existed when UserA opened his copy of the Form.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007