Creating Queries with a User Interface Form!!!!!!

[Kckronic21]

I am trying to create different types of queries by using a form. I have 4 combo boxes on a Form called Query_Form: 1)Query_Name_combobox 2)Table_Name_combobox 3)Field_Name_combobox 4)Criteria_combobox. My question is how can I run a query based on the values from these comobo boxes? Thanks!

 

[hirenJ]

The first thing to do is set up parameters in your query -- you then place these parameters in your query using brackets i.e. -- in criteria grid specify parameter..

[criteria1]

You then need to pass these parameters in code to the query---
you can do this using an ADO recordset, command and parameter objects --

hope this helps

Hj

)