[AccessD] Access lockup when using record selector search

[Stuart McLachlan]

Refresh method 
Use the Refresh method to immediately update 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. The Refresh method shows only changes that have been made 
to the current set of records; it doesn't reflect new records or deleted records in the record 
source. 

Requery method 
Use the Requery method to update the data underlying a form or control to reflect records 
that are new to or have been deleted from the record source since it was last requeried. 
If you want to requery a control that isn't on the active object, you must use this method, not 
the Requery action or its corresponding DoCmd.Requery method.
 

On 27 Mar 2021 at 8:40, Stuart McLachlan wrote:

 > There is a lot of confusion between Refresh and Requery.
>