Conditional Formating for each Record

[PosseJohn]

I have a form that contains 2 address's, one for the business, and another
for mailing.

I also have a checkbox (linked to a DB field) that show whether or not both
address's are the same.

If they are the same for the displayed record, I want the font color of the
label to be a dim gray, and the entry fields for the second address to be
disabled.

I already know how to control the color and enabling of the entry fields.

How do I update these parameters as the user scrolls thru the address book?
Where do detect when the form changes to another record?

 

[Gina Whipp]

PosseJohn,

Sounds like you are using a Continuous Form and VBA to change the colors.
However, to get that to work on a Continuous Form you will need to use
Conditional Formatting OR you need to put your code in the On_Current event
of your form?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm