Using a form to open a form?

[tc197]

Hi everyone and thanks for your help!

I was wondering if it is possible to have a form open another form. Essentially I have 5 different forms all used for data entry. Depending on the product determines which form needs to be filled out. I was wondering if it was possible to have sort of a main menu that would allow the user to choose which form they would like to open. On the front end of my database the user doesn't need to open anything other than the 5 forms and I know that you can set access to open a specific form upon opening the database... so I was wondering if that form could be a main menu which other forms could be chosen from. Do you follow my idea?



So the user clicks on the MSAccess program -> database opens and a form pops up with 5 options, form 1, form 2, form 3 , form 4, form 5 -> user selects a form from the list -> form opens up and user enters data as usual -> user finishes entering data and either closes form or clicks a button to return to the "main menu" form. Is it possible/ not too complicated? Thanks for the help!

[pbaldy]

Easy; with 5 buttons you could have each open a different form using OpenForm. You could use a combo with the form names and a button:

DoCmd.OpenForm Me.ComboName

[tc197]

Easy; with 5 buttons you could have each open a different form using OpenForm. You could use a combo with the form names and a button:

DoCmd.OpenForm Me.ComboName

I'm glad that it's easy but I don't follow the docmd.openform thing.

Where do I start in access? With a new form? and did you give me the choice of 5 buttons or a combo box? Or was that all part of the same option. I'm sorry I don't understand the language behind everything quite yet. Thanks for the reply though!

[pbaldy]

Yes, you'd start with a new blank form and make it the startup form. I gave you a choice between 5 buttons and a combo box/single button. The code was for the second option.

[tc197]

Yes, you'd start with a new blank form and make it the startup form. I gave you a choice between 5 buttons and a combo box/single button. The code was for the second option.

Ok perfect. I kind of prefer the 5 button option. How do I go about writing the code to give the button it's "assignment"? In your example was the "Me" the name of the form?

[pbaldy]

The 5 button option wouldn't require that. The button wizard will do it for you, but the VBA code would be:

DoCmd.OpenForm "FormName"

If you haven't used VBA code yet:

http://www.baldyweb.com/FirstVBA.htm

[tc197]

The 5 button option wouldn't require that. The button wizard will do it for you, but the VBA code would be:

DoCmd.OpenForm "FormName"

If you haven't used VBA code yet:

http://www.baldyweb.com/FirstVBA.htm

Thanks for the help! This is exactly what I need!

[pbaldy]

Happy to help!