individual rows

[ariel81]

Hi,

refer to the (record.jpg)

the whole record is identified as " rst.RecordCount " ( red color box).
how to identify each individual rows ( blue color box)?

 

[The_Doc_Man]

To what purpose would you wish to identify a specific row?

I sense you are about to apply Excel logic to an Access database, to which all I can say is "That dog don't hunt."

And by the way, rst.RecordCount merely provides the number of records in the recordset. It does NOT reference all records at once in the normal sense of "referencing a record."

 

[boblarson]

And a RECORD is all Column attributes of a particular ROW. A Record would be represented by your blue box. The red box would be a recordset.