I am createing a query in VBA, saving it, then running it, and it does not work.

But if I go into SQL mode, copy and past it into a new query it runs. I have comparied the one that does not work and the one that does and they are identical.

What's up?!!

Here is my code to create it:

Dim dbsNorthwind As Database
    Dim qdfNew As QueryDef
    Dim qdfLoop As QueryDef
    Dim prpLoop As Property

    Set dbsNorthwind = CurrentDb 'OpenDatabase

    ' Create new QueryDef object. Because it has a name, it is automatically appended to the QueryDefs collection.
 Debug.Print strSQL_String
Set qdfNew = dbsNorthwind.CreateQueryDef("YourQueryResults", strSQL_String)

__________________
Mitch

Hi Mitch

Where do you have your strSQL_String

Set something like this

strSQL_String = "SELECT * FROM Table"

-vemaju