Open Form based on parameter

[khurley]

I have a few forms i created with unbound excel spreadsheets.

I'd like to open a form from a switchboard. My users use run time access... What i'd like is for the user to click on the button to Open a form and then be able to A) type in the form name in a dialog box and click OK and that form would open or B) Select from a drop down list of the available forms.

Is this possible?

I can't find anywhere to help with parameters when opening a form and i don't do to much with VBA.... But i'll try!

Thanks for any suggestions!

Kathy

 

[Trevil]

With a comboBox, try:
DoCmd.OpenForm Me.cboFormName, acNormal

"Hmmm, it worked when I tested it....

 

[dmksas]

You can capture the form names by using the AccessObjects Collection..

It does however depend on what version of Access you are using.

If A2K or above then I'll demonstrate.

Danny

Never Think Impossible

 

[khurley]

i'm using Access 2003...

thanks for the help... i'll be trying your ideas in the morning when I'm back at work!

Kath