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

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?
 
G

Guest

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
 

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

Top