Originally Posted by
john134
The table updates with the new record only when I click on the
RefreshAll button.
I'm not really sure you understand what Refresh (and hence RefreshAll) does; it has nothing to so with the Table reflecting new Records. Tables show New Records when the Record is Saved.
From Help:
The Refresh method immediately updates the records in the underlying record source for a specified form or datasheet to reflect changes made to the data by you and other users in a multiuser environment.
In other words, if you're UserA...and UserB edits a given Record...when UserA's Form is used is Refreshed it will then show the edit that UserB made to that given Record...and Refresh only applies to Records that existed when UserA was first Loaded...it will not show New Records that have been added since UserA's Form was Loaded. To do that, it has to be Requeried, as was mentioned above.
If hitting RefeshAll is 'causing' the New Record to appear in the Table, it's because you've exited the Record, in order to hit RefreshAll, and therefore the Record is Saved...just as it would be if you exited the Record by going to another Record or by Closing 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