Database Open

[MacroAlan]

I code VBA in both Excel and Access. Having a meltdown this morning and cannot remember.

In Excel there is an event to run something when the spreadsheet is open: Autpen or Workbook_Open; what is the equivalent event in Access VBA.

I need to create a couple lookup tables when the DB is opened.



Alan

 

[MajP]

Either put the code in a startup form (which can be a splash screen or invisible) or create an autoexec macro

https://support.office.com/en-us/ar...database-98ba1508-dcc6-4e0f-9698-a4755e548124