Main Menu form

[elyse]

Hello,

I have about 150 forms that I need to create, I there a way to create a
main form for end users, where they can either select from a list of forms or
perform a search to find a form of thier choice?

If so, would I need to type every form name into my SQL Server database and
use this table as a drop-down object on my form?

Thanks
Elyse

 

[Adam Harding]

Hi again

Easiest way is to create a query main form to allow them to pick from ddlist
or search by name or FORMID

This would require each name and ID to be recorded in a table to reference.

After that is done you will have to set rules that say if DDList equals
Form1 then open form 1 and close this form and so on.

The search would be more difficult unless you could categorise them.
Certain forms belong in HR, Purchase ledger etc. and then offer another
filter on some other criteria and to stop mistypes use their selections to
restrict filter the DDList so a chance of mistype is reduced.

Cheers Adam