Hi All,
I have a query (qrypackage1) that collects individual records from a table (tblproducts). I use this query to display certain products together as they form a final packaged product. The result of said query can then be displayed on reports etc.
The thing is...tblproducts consists of many individual products that make up many individual final, packaged products, so I have many queries for each packaged product. All good so far.
But...what I'd like to accomplish is the following:
Have a combo box (combopackages) on a form (frmquote) that contains the name of each final, packaged product, that when selected, runs the corresponding package query and then transfers the query results into a set of text boxes on that open from.
I know how to display a single query (bound to a combo box) and copy out data to a text box on a form. But.. what I'd like to do is choose from a selection of queries. This is where I'm stuck.
I assume I need to use combopackages to select my desired query from a list, then use VBA to run that chosen query and store/display it temporarily in another combo box, and then copy out from THAT into the form text fields? This is what I cannot figure out how to do.
Any help would be greatly appreciated.
I have a query (qrypackage1) that collects individual records from a table (tblproducts). I use this query to display certain products together as they form a final packaged product. The result of said query can then be displayed on reports etc.
The thing is...tblproducts consists of many individual products that make up many individual final, packaged products, so I have many queries for each packaged product. All good so far.
But...what I'd like to accomplish is the following:
Have a combo box (combopackages) on a form (frmquote) that contains the name of each final, packaged product, that when selected, runs the corresponding package query and then transfers the query results into a set of text boxes on that open from.
I know how to display a single query (bound to a combo box) and copy out data to a text box on a form. But.. what I'd like to do is choose from a selection of queries. This is where I'm stuck.
I assume I need to use combopackages to select my desired query from a list, then use VBA to run that chosen query and store/display it temporarily in another combo box, and then copy out from THAT into the form text fields? This is what I cannot figure out how to do.
Any help would be greatly appreciated.
Last edited: