If I read this correctly, you want to open a form by
choosing it's name from a combo box?
If that's the case then, here is one possible solution:
Create the combo box and in the data field use:
SELECT MSysObjects.Name, MSysObjects.Type
as the SQL statement. This will give you a combo box
with all of your form names in the database. Then, on the
AfterUpdate event of the combo box, write this code:
Dim strFormName as String
strFormName = Me.ComboBox.Value
This will open the form.
If you have additional forms in your database that you do
not want to show up in the combo box, you could make a
query in design view and customize the criteria to find
only the forms you want.
Example: Use a uniform naming convention for the forms
that your users will access from the combo box (usrForm1,
usrForm2, etc.) In the Name field of the MSysObjects
table, write criteria: Like "usr" & "*"
This will return all of the forms that have that prefix.
You'd use the same code on the combo box in this
Hope this helps,