Query Circular Reference

R

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
 
D

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)
 
R

Ron

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

Thanks

Ron
 
R

Ron

That works!

Thanks for your help.

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

?currentdb.querydefs("myqueryname").sql

(david)





.
Click to expand...
 
Top