Difference Between Open and Load of Forms

[TrevorJ]

This question has been split from another thread (Difference Between Open and Load of Forms) but is valuable in its own right.
-NeoPa.

What is the difference between the OnOpen procedure and the OnLoad procedure?
Regards,
TrevorJ.

[twinnyfo]

The notebook icon is for Reports.....

Other mods: Some leeway in answering this final question from the gallery?

Think of Forms and Reports as a dishwasher. You have to open it before you load it. Opening a form simply begins the process of generating the form and setting things up, so this can be canceled if necessary (and then the form will close without anything happening. Loading the form brings all the data into the form and fully prepares it for use.

I believe the sequence of events for opening is like this:

Open > Load > Resize > Activate > Current

So, you can create procedures that fire at different times during a form's "birth cycle". Keep in mind that if you need to use data from the Form, it will not be available until the "OnLoad" stage.

Hope this hepps!

[TrevorJ]

Got it, thanks again.
Trevor.

[NeoPa]

How can I assign your post as Best Answer if I give leeway ? ;-)