Query Circular Reference

  • Thread starter Thread starter Ron
  • Start date Start date
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
 
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)
 
Thanks for the info David but I'm using an ADO recordset.
Any other suggestions

Thanks

Ron
 
That works!

Thanks for your help.

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

?currentdb.querydefs("myqueryname").sql

(david)





.
Click to expand...
 
Back
Top