bruceblack
Registered User.
- Local time
- Today, 01:51
- Joined
- Jun 30, 2017
- Messages
- 119
Hi all,
I am stuck quiet a bit with a simple little thing i try to do.
I have a continuous form with a table record source. All i like to do is that when i select a field (click on a control) the backcolor changes to green (for example). My expected result is that only that one specific field changes to green, but it does the entire column.
I am puzzled, since every row has a unique ID. I tried a few things, like Me. and Me! and Me.control... etc etc.
Nothing seems to work. Currently i have this (...im trying to make field A green) :
Private Sub A_Click()
lngGreen = 8179068
Me!A.BackColor = lngGreen
DoCmd.RunCommand acCmdSaveRecord
Else
End If
End Sub
But this changes the entire column to green. Please help :S
I am stuck quiet a bit with a simple little thing i try to do.
I have a continuous form with a table record source. All i like to do is that when i select a field (click on a control) the backcolor changes to green (for example). My expected result is that only that one specific field changes to green, but it does the entire column.
I am puzzled, since every row has a unique ID. I tried a few things, like Me. and Me! and Me.control... etc etc.
Nothing seems to work. Currently i have this (...im trying to make field A green) :
Private Sub A_Click()
lngGreen = 8179068
Me!A.BackColor = lngGreen
DoCmd.RunCommand acCmdSaveRecord
Else
End If
End Sub
But this changes the entire column to green. Please help :S