List or Combo Boxes

[prose7777]

i have an access database that has 20 diffrent forms to choose from . i am makeing a switchboard form , i wanted to have a list or combo box to open these forms. Can anyone tell me if and how i can do this

 

[Mile-O]

Prefix all you forms you want to select with cfrm:

Ensure your control's RowSourceType is set to Table/Query. Open up the query design grid from your combobox or listbox's RowSource.

Switch to SQL View:

An SQL Statement like this should finish it off...

SELECT Mid(Name, 5) AS FormNames
FROM MSysObjects
WHERE Left(Name, 4) = "cfrm"
ORDER BY Mid(Name, 5);

 

[prose7777]

thanks alot.. but how would i launch the corresponding form?

 

[WayneRyan]

prose,

You can use the AfterUpdate event of your combo to put:

DoCmd.OpenForm "cfrm" & Me.Combo

Wayne

 

[prose7777]

thanks alot guys...this will work...