Set SQL of Query with VB?

[Bullsandbears123]

How can I set the SQL for a Query using VB.

I have tried
qryQueryname.recordsource=SQLstring

qryQueryname being the query's name and
SQLString being the SQL statement I want to set it to.

but nothing works.

Thanks

 

[xuanb]

If I understand you right SQLString and qryQueryname are both the same thing.
What you want is

SQLString = "SELECT * FROM tblYourTable;"

Me.RecordSource = SQLString

RecordSource is a Form Property

 

[Bullsandbears123]

Let me clarify.
I have a query I would like to open and run.
The query would be independent of the form.
The form is used just to set the parameters.
For instantance I have to define 2 values in the query. Theses values come from a cbo box list, and these values are dependent on a another cbobox choice.
The query needs these values to run correctly.
So I am trying to set the SQL built using these cbobox values and then trying to set the SQL for the Original query. After the query is set to the SQL I need to run a report from the changed Query. All dependent on the cbo box values.
THanks

 

[hwkranger]

Dim mysql As QueryDef
Dim db As Database

Set db = CurrentDb()
Set mysql = db.QueryDefs("your query name&quot
With mysql
.SQL = "Your query def"
End With
Set mysql = Nothing


Randall Vollen
National City Bank Corp.

 

[Bullsandbears123]

I tried your(hwkranger) code and I recieved a compile error: User-defined type not defined. When setting the
dim mysql as queryDef
dim db as database

Do I need to add a component to use the code. It looks like "querydef" is some sort of function do I need a function added. I am running the code within Access.
THANKS!

 

[Bullsandbears123]

IT WORKS!
I added the DAO 3.6 component an all is well.

Thanks it really helped a Lot!