Open New Form Based on Drop Down Selection

[tpearo]

Is it possible to have a list box that lists the forms in your database and allow the user to select a form from the list and when selected launch or open that particular form?
I have about 8 forms that have fields that need to be filled out based upon the testing my technicians do in my lab. I want them to be able to select the test that they will perform based on a drop-down or list box... and when they select the test it open the appropriate form for that test.
Any help would be appreciated.

Tp

 

[PHV]

Set the RowSource property to:
SELECT Name FROM MsysObjects WHERE Type=-32768

In the AfterUpdate event procedure of the listbox:
DoCmd.OpenForm Me![listbox name].Value

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886