change background color of a record in a form (1 Viewer)

[joeserrone]

Hello everyone,
I have a tabular form that displays records from a query, when a user doubleclicks on a record a second more in depth form appears. What I wanted to do is give the user a visual reference to what records were viewed and which ones were not. So I thought I would place me.nameofTextBox.backcolor = 8421504
but I realized that it changes all the background colors of all the records. Is there a way to change the background color just for the record selected in the form?

 

[dkinley]

You can see if this is what you mean ...

http://www.mvps.org/access/forms/frm0047.htm

-dK

 

[ajetrumpet]

if there are users scrolling through the records and clicking the details of everyone, and you want to show which ones were opened on a detailed basis, then maybe you could pick out a unique value from each record, and the control that those values are stored in, record those values in VBA (maybe an array?) when each record is viewed in detail, and then use the OnCurrent() event of the form to check weather or not the boxes contain those values of records that have been viewed in detail ?

This is a little complicated, but it would get done what you want to get done..