Access 2013 - Opening the last form or table that was accessed on start-up
Posted on 2014-10-13
I have an access 2013 database that is opening the last form or table that was accessed when it starts-up
I have a start-up form that runs a vba app to create a table on start-up then it closes the start-up form and opens a master form.
The start-up form is listed under the Display form in Current Database Options
code in the start-up form is
Private Sub Form_Close()
DoCmd.OpenForm "0_MasterDataFrm", acNormal
Private Sub Form_Open(Cancel As Integer)
DoCmd.Close acForm, "0_STARTUP"