help with combo box nightmare

[Bigthinkor]

hello everyone
I am new to the forum and I was hoping that you guys could help me out. I have a combo box on my form inside of the combo box is a list of all my forms. I am trying to get the combo box to allow the user to click on a form and it opens up. I am currently running Access 2010I have tried this with no success
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND
(MSysObjects.Type)=-32768 ORDER BY MSysObjects.Name;



Private Sub FormOpenCombo_AfterUpdate()
stDocName = Me.FormOpenCombo
DoCmd.OpenForm stDocName
End Sub

[ajetrumpet]

well you haven't said what ''no success'' is. care to elaborate? what's the problem other than ''its not working''??

[Access_Blaster]

hello everyone
I am new to the forum and I was hoping that you guys could help me out. I have a combo box on my form inside of the combo box is a list of all my forms. I am trying to get the combo box to allow the user to click on a form and it opens up. I am currently running Access 2010I have tried this with no success
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND
(MSysObjects.Type)=-32768 ORDER BY MSysObjects.Name;

Private Sub FormOpenCombo_AfterUpdate()
stDocName = Me.FormOpenCombo
DoCmd.OpenForm stDocName
End Sub

This is the name of your combo >> FormOpenCombo
Richard