Query Circular Reference

[Ron]

Help! I have a query in Access 2000 that returns a
circular reference error message and I am no longer able
to get past the error to change the query. How can I
break past the error message and get into design view to
make the changes.

Thanks

Ron

 

[david epsom dot com dot au]

open the VBA window (new module), view the immediate window,
and type
?current.querydefs("myqyueryname").sql

copy the result to Word or Notepad, change as required,
then create a new query with the new sql.


(david)

 

[Ron]

Thanks for the info David but I'm using an ADO recordset.
Any other suggestions

Thanks

Ron

 

[Ron]

That works!

Thanks for your help.

Ron

-----Original Message----- recordset.
transcription error! should have been

?currentdb.querydefs("myqueryname").sql

(david)





.