VBA Code Behind Button For Single Record/Form Conditioning

[outlook]

Hi All,

I have a button which appears on each record of a form. I want the user to be able to click on it, and then it colours the data within the form using conditional formatting.

The only problem is that the current VBA code I have, colours every record, and not the current one.

Can anyone suggest some code for me?

I can paste my code on here if it will help.

Thank you.

 

[revans]

This is a little old but it might still do what you want.

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

hth,

Rich

 

[outlook]

Thank you for your reply, but that link doesn't really help me.

Here is my VBA event code:

Private Sub Check_Completed_Click()
Me.[INTRO FEE %].BackColor = 68004
Me.[INTRO FEE £].BackColor = 68004
Me.[REDUCTION £].BackColor = 68004
End Sub

The button that actions this code is on the form, but when pressed it colours every record, not just the current one.

Maybe the code is wrong, but I'm not sure how to change it.

Please help!!!