How do I create a switch board that holds a number of forms?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a Data base for Travel Unit where I work.
I have designed a Five Tables,Quaries and Forms .

Now I want to desing a switch board to hold all these forms, which should be
open with a command bottons.
How do I go about this?
 
You could create a new form and call it Switchboard and simply insert a few
buttons onto the form. Place this code behine Button 1
Private Sub Button1_Click()
DoCmd.OpenForm "FormName1", acNormal, "", "", , acNormal
End Sub

Place this behind Button 2
Private Sub Button2_Click()
DoCmd.OpenForm "FormName2", acNormal, "", "", , acNormal
End Sub


Place this behind Button 3
Private Sub Button3_Click()
DoCmd.OpenForm "FormName3", acNormal, "", "", , acNormal
End Sub

Hope this helps
 
Back
Top