I Ig Mar 3, 2005 #1 Hi How to populate combo with names of all forms in the project in Access 2000? Thanks
B Brendan Reynolds Mar 3, 2005 #2 Private Sub Combo0_Enter() Dim aob As AccessObject Dim strList As String For Each aob In CurrentProject.AllForms strList = strList & aob.Name & ";" Next aob Me!Combo0.RowSourceType = "Value List" Me!Combo0.RowSource = strList End Sub
Private Sub Combo0_Enter() Dim aob As AccessObject Dim strList As String For Each aob In CurrentProject.AllForms strList = strList & aob.Name & ";" Next aob Me!Combo0.RowSourceType = "Value List" Me!Combo0.RowSource = strList End Sub
B Bob Quintal Mar 3, 2005 #3 Hi How to populate combo with names of all forms in the project in Access 2000? Thanks Click to expand... Set the rowsource to: SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Type=- 32768;
Hi How to populate combo with names of all forms in the project in Access 2000? Thanks Click to expand... Set the rowsource to: SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Type=- 32768;
