Here is a little more info about each of the objects: Q_Customers is the query that produces the desired list of results T_States is the temporary table holding the list of selected parametersį_Parameter_Form is the form containing the multiselect list box M_Customers is a table storing our customer data There are 4 Access objects used for the multiselect parameter form demonstration: The query can then be used directly or used as a data source for a report. ![]() In this example we will demonstrate the use of an extended select list box as a method to pass parameters to an Access query. ![]() Passing parameters to queries and reports can be a stumbling block for the novice Microsoft Access programmers. ![]() Query Parameter Form in Access Pass Parameters to Access Query
0 Comments
Leave a Reply. |