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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem in Word VBA, Please Help 0
Opening OLE Object Sync Issue within VBA Code 0
HELP! VBA Code Stopping on Open 3
Dialog form opens wrong 4
Change control in dialog form 1
Excel VBA - Problem with Closing Print Preview 0
Access 2000, VBA Code corrupt 11
Example Of VBA SQL Statement 0

Back
Top