Automatically change an Access Queries

[Kathy]

Is there a way in code to automatically change the criteria in a
query? I want to make the change based on a value selected in a drop
down box.

Thanks,

 

[Van T. Dinh]

You can use the QueryDef Object (DAO Library needed in the References) to
modify the SQL String of the Query. You can also use ADO Catalog.

 

[John Vinson]

Is there a way in code to automatically change the criteria in a
query? I want to make the change based on a value selected in a drop
down box.

Thanks,

The simplest way is to directly reference the form and the combo box
in the Criteria cell of the query grid: just type

=[Forms]![NameOfYourForm]![NameOfYourComboBox]

using your own form and combo box names, of course. The form must be
open for this to work; but you can put a command button on the form to
open a Report or another Form in which to display the query data.

 

[tom]

Yes... open the VB editior help file and lookup DoCmd.RunSQL...
HTH.
Tom.