How do you make two different forms have two different startup settings?

  • Thread starter Thread starter MizPatty
  • Start date Start date
M

MizPatty

I have one table and two forms. One form I want to start
up with no menus or tool bars and in read only mode. The
other form I want to start up with all menus and all edit,
add, delete, etc. options. When I set the startup options,
whatever I select, it applies to both forms. I can't find
a way to have two different startup settings in the
Startup option. Any ideas?
Thanks!
 
The startup options are for when Access starts and will apply to everything.

To make the form read only, set the form's Recordset Type to Snapshot. This
is on the Data tab of the form's Properties sheet.

To hide the toolbars when one form is open, you can hide them in the form's
Open event and restore them in the form's Close event.

Private Sub Form_Close()
DoCmd.ShowToolbar "Menu Bar", acToolbarWhereApprop
DoCmd.ShowToolbar "Form View", acToolbarWhereApprop
DoCmd.ShowToolbar "Formatting (Form/Report)", acToolbarWhereApprop
End Sub

Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
DoCmd.ShowToolbar "Form View", acToolbarNo
DoCmd.ShowToolbar "Formatting (Form/Report)", acToolbarNo
End Sub
 
Back
Top