Changing a Query

[savix]

Hi,
How can I change certain values of an SQL query with a macro? What I'm trying to do, is to adapt the queries to the specifications of my forms.
Thanks for your help

Sav

 

[tkpstock]

mySQL = "SELECT * FROM myTable WHERE field1 = '" & TextBox1.Value & "' AND field2 = '" & TextBox2.Value & "'"

CurrentDB.QueryDefs("myQuery").SQL = mySQL

HTH

 

[savix]

thanx!....