Updatable QueryDef

[tseh]

I have created a QueryDef at runtime and wish to update one of the fields. How can I (if possible) do this using Access 2000?

Dim qdfTemp As QueryDef
Dim strSQL As String

Set qdfTemp = gDB.QueryDefs!qryOrders

strSQL = 'My select statement

qdfTemp.sql = strSQL

I later use this query in various forms.
Thanks.

 

[Guest_imported]

Are you using the query to locate a record so you can then update that record?
[sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]