Forms - OnLoad vs OnOpen (All versions)

[kwvh]

Is there a reference book, or web link that shows the order in which events are executed? For example, Which loads first, OnLoad or OnOpen (or OnCurrent). What are the advantages of using both, and not just one?

Thanks in advance for your ideas and references.

Ken

[HansV]

See Load Event [Access 2003 VBA Language Reference]. It's similar for other versions of Access. The order is

Open > Load > Resize > Activate > Current

The On Open event can be canceled, so if you need to prevent the form from being opened under some conditions, you should use this. But it occurs before the record source is loaded, so if you need to do something with the data, the On Load event is better.

[kwvh]

Hans,

thank you for help. You are awesome!