View record values in recordset during debug

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way (what is best way) to view the field values of each record as
you process through a recordset while in debug mode? The results I am
expecting are not happening, and before I post up my code for help, I will
try to debug myself. I need to see which record I am processing and the
values being compared between 2 tables (recordsets).

Thanks in advance

Kenny A.
 
Hi Kenny

While you are stepping through the code you can do either of the following...

Click View & then "Watch Window" - here you can add specific variables such
as MyRecordset1.Field1 and MyRecordset1.RecordCount.

Or Click View & then "Locals Window" - here you can see all local variables,
including recordsets and can browse the recordset structure in a tree like
form

Hope this helps and good luck debugging

Andy Hull
 
Andy,
Thanks for the reply. A little while after sending the post, I figured it
out. Boy do I feel silly. Thanks again, I can always count on help from this
board no matter how easy or hard.

Kenny A.
 
Back
Top