Difference between opening and loading a form

S

Susan Kennedy

On Open is as the form is itself opened and before the
data is retrieved.

On Load is after the data has been retrieved and loaded
into the form.
 
V

Van T. Dinh

I am sure there are a number of differences internally
(which I don't know) but the only notable difference you
need to know is the Open can be cancelled and Load is not
cancellable.

HTH
Van T. Dinh
MVP (Access)
 
V

Van T. Dinh

It is not entirely correct, actually.

If you check the Recordset(Clone), you will find that (same) of the data is
already there in the Form_Open Event.
 
Top