open other forms in form main

Milade8080

Registered User.
Local time
Today, 07:54
Joined
Mar 6, 2014
Messages
34
I have a main form and several other forms
How can Type the name of the other forms, the main form, and pressing the button "Open" to open other forms
Tanks.
(Something like the image below)
my access file
 

Attachments

  • 11.jpg
    11.jpg
    15.2 KB · Views: 119
  • form.zip
    form.zip
    58.8 KB · Views: 111
How can you expect users to know the form names? Don't think I'd do it, but:

DoCmd.OpenForm Me.TextboxName
 
Or explore http://access.mvps.org/access/queries/qry0002.htm to give you a list of all the Forms in your database... use at peril if you're trying to lock down some forms/only open some after others are up!

If the list isn't too long and not expected to change often, you can just hand-code a combobox to do the same thing with only the forms you want them to open directly.
 

Users who are viewing this thread

Back
Top Bottom