Using MS Access 2003, change the color of a singe row in a continuous forms subform

Experts,

I have a subform accessing a single table, the subform is set to continuous forms with an update button in each row. When the update button is clicked, I want to change the color of the detail ONLY for the row selected. Instead it's changing the color for all rows.

Can this be done.

Feel free to give anwers using VBA.
aijrealAsked:
Who is Participating?
 
puppydogbuddyConnect With a Mentor Commented:
Try placing the following code in your update button:
If Me.CurrentRecord Then
   Me.BackColor = vbRed
End If
________________________________________

try this if the above doesn't work, but this will only highlight one control:
Open the subform in Design View, and select the first control.
Go to Format | Conditional Formatting.
Under Condition 1, select Field Has Focus.
Click the Fill/Back Color button, and select yellow.
Click OK.
0
 
aijrealAuthor Commented:
Thankyou!
0
All Courses

From novice to tech pro — start learning today.