<div>
The Set is causing the problem, I think. &nbsp;Try something like:<br />
<br />
Dim qdf As DAO.QueryDef<br />
Set qdf = CurrentDb.QueryDefs(&quot;qry13<wbr />bCreditSta<wbr />tus&quot;)<br />
qdf.SQL = &quot;SELECT Category FROM Categories&quot;
</div>


The Set is causing the problem, I think.  Try something like:

Dim qdf As DAO.QueryDef
Set qdf = CurrentDb.QueryDefs("qry13bCreditStatus")
qdf.SQL = "SELECT Category FROM Categories"

<div>
I think my answer would have worked too!! &nbsp;Oh well.
</div>


I think my answer would have worked too!!  Oh well.

<div>
armchair_scouse,<br />
<br />
Yes, it would have. &nbsp;For the record, I would not object to a split :)<br />
<br />
Patrick
</div>


armchair_scouse,

Yes, it would have.  For the record, I would not object to a split :)

Patrick

<div>
<div class="content wysiwyg-content">
I am trying to compile my mdb in Access 2010 and this line of code is throwing up an error:<br />
<br />
Set db.QueryDefs(&quot;qry13bCredit<wbr />Status&quot;).S<wbr />QL = stSQL<br />
<br />
<br />
The error is &quot;Invalid use of property&quot;<br />
<br />
Previously in the same procedure:<br />
<br />
set db=opendatabase(stdatapath<wbr />)<br />
<br />
If you can see what I'm doing wrong that would be great.
</div>
</div>


I am trying to compile my mdb in Access 2010 and this line of code is throwing up an error:

Set db.QueryDefs("qry13bCreditStatus").SQL = stSQL


The error is "Invalid use of property"

Previously in the same procedure:

set db=opendatabase(stdatapath)

If you can see what I'm doing wrong that would be great.

Defining a Query in code

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.