G
Guest
Hey
I was wondering if there is a way to have the titles of the queries appear in a dropdown box, and then run a command button/report from the selection of the query. I tried the following code but it gives me every report, query, table, etc etc in my dropdown box. Is there a way to pick which queries I want in my dropdown? Thank you very much
Set the combo box Row Source Type property to Table/Query
Set the Rowsource to
SELECT MSysObjects.Name FROM MSysObjects WHER
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER B
MSysObjects.Name
Set the bound column to 1
Set the ColumnWidths property to 1
Set the LimitTo List to Yes
Set the AutoExpand to Yes
Then, if you wanted to run any one particular query, based upon i
being selected in this combo box, code the AfteUpdate event
DoCmd.OpenQuery Me!ComboNam
I was wondering if there is a way to have the titles of the queries appear in a dropdown box, and then run a command button/report from the selection of the query. I tried the following code but it gives me every report, query, table, etc etc in my dropdown box. Is there a way to pick which queries I want in my dropdown? Thank you very much
Set the combo box Row Source Type property to Table/Query
Set the Rowsource to
SELECT MSysObjects.Name FROM MSysObjects WHER
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER B
MSysObjects.Name
Set the bound column to 1
Set the ColumnWidths property to 1
Set the LimitTo List to Yes
Set the AutoExpand to Yes
Then, if you wanted to run any one particular query, based upon i
being selected in this combo box, code the AfteUpdate event
DoCmd.OpenQuery Me!ComboNam