open other forms in form main (1 Viewer)

Milade8080

Registered User.
Local time
Today, 15:06
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: 87
  • form.zip
    58.8 KB · Views: 77

pbaldy

Wino Moderator
Staff member
Local time
Today, 15:06
Joined
Aug 30, 2003
Messages
36,125
How can you expect users to know the form names? Don't think I'd do it, but:

DoCmd.OpenForm Me.TextboxName
 

David R

I know a few things...
Local time
Today, 17:06
Joined
Oct 23, 2001
Messages
2,633
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

Top Bottom