Run vba on form opening

  • Thread starter Thread starter Guest
  • Start date Start date
The form has an On Open event. You can access it through the event
properties of the form.
 
How do you run code when a form is opened? Can i embed the code in the form?

James
Click to expand...

Yes to both. Open the Form in design view, and view its Properties.
Select the Events tab, and click the ... icon by either the Open event
(which fires first, before the Form's recordset has been opened or any
of its controls populated; this event can be calcelled) or its Load
event (fires before the user gets control but after the controls have
been filled).
 
Back
Top