alternative means of opening forms

[John]

I am in the process of creating a database for one of the
divisions. When it is all done, there will be about 40
forms. It's what they wanted. But, I can't see having 40
buttons (minimum) even on a separate form to select what
the user wants. Each user will be looking at many
different forms during the course of their work.

Does anyone have any other thoughts or experience needing
to do this due to a high number of forms? Several of my
thoughts was a listbox or a combobox. How would that
work. Normally, my work does not contain that many forms
and buttons suffice. They threw me a curve on this one.

Any ideas, thoughts, suggestions, etc would really be
great. And even a starting push in the direction would be
good, too.

*** John

 

[John]

Albert, I know what you're saying, but I do what they
want and they wanted each process to have its own form.
This is what the 15 - 20 end users wanted and this is
what they'll get. And I don't have a lot of time to do
it in (how unusual that sounds).
So, if there is a way for the combo box to be used, would
like to know how.
Thanks. And again, I hear what you're sayin'.
*** John

 

[John]

Albert, I know what you're saying, but I do what they
want and they wanted each process to have its own form.
This is what the 15 - 20 end users wanted and this is
what they'll get. And I don't have a lot of time to do
it in (how unusual that sounds).
So, if there is a way for the combo box to be used, would
like to know how.
Thanks. And again, I hear what you're sayin'.
*** John

 

[Albert D. Kallal]

A comb box?

Sure, that is a very good idea.

You can simply make a table with the form name, and also a nice description.

Make the "form name" the primary key.

Now, on a form, use the combo box wizard to build a combo box that lists the
forms (and more importantly, the "nice" description that explains the form.

You will notice that I did exactly this in many of those screen shots in my
last post:

Now, the user can select a form in the combo box, and right beside the box,
you have a bunch to "view form"

The code behind the button is going to be

docmd.OpenFrom me.MyComboBox

That is it...one line of code.

I used listboxes in my examples I showed. However, a combo box is better if
you have a "lot" of forms.