Form opens forms not too cool

[Tekhelpnet]

I have a few sets of reports for different departments.
I need a form that will have names of the departments and when they click it should bring that department feom with bunch of reports to run.

My question is how to make it pretty?

I know I can have a Main Form with macro running on click event opening THE form that had been called.

Anything fancier then this?

 

[lameid]

I would have a table for departments.

Then I would have a form name field in this table.

You could then have a combo box where they would select the department (Departement would be bound with the form name as the second column in the row source).

Then have a single buton that opens that code...

Sub CmdReportOpen_Click

     Docmd.openform Me!cboName.Column(1)
End Sub

 

[Tekhelpnet]

OK but behind the form there are 5 forms are still attached to this one right?

Also what I forgot to mention I want users to have only one form without a whole Access.mdb is this possible and I think it is but if one form has another 5 to call wouldn't having one form for a user to see become impossible?

 

[Crowley16]

if you want to only allow one form, then either put a back button on each form so users can navigate back to the selection form, or use a tabbed control and keep everything on one big form.

or you can build a set of custom menu options pointing to the relevant report forms

--------------------
Procrastinate Now!

 

[lameid]

Tekhelpnet,

You have to have a file for every form. Most likely you will have an MDB or if it is complied an MDE.

I'm not sure there is a purpose to limiting youself to one form but Crowley16's suggestions are good for multiple forms.

If that doesn't help, can you be more specific?