Formatting a Report from a Command Button

[Okibi07]

Hi all,

So I have a report that lists different clients, their contact information, and their various representatives.
What I want to be able to do is have a button next to every client entry which the user can click. Once the button is clicked, I want the "person name" box in the report to be formatted to have a yellow background.

The purpose of doing this is so after a couple of days when we come back to the report, we can easily see by the yellow background which people we have to follow up with.

I don't think conditional formatting will work because I have so many different "person names" in the report that it would go above the 3 rule limit, only solution in VBA.

The button I created is called "Format", and this is the VBA code I have tried:

Private Sub Format_Click ()
Me.Person_Name.BackColor = vbYellow
End Sub

Obviously not working. Would love everyone's input. Thanks so much!

 

[Okibi07]

Anyone have any thoughts? Still stuck on this.

 

[Mihail]

I think that this article will help you.
Also take a look to this thread.

If you google a little bit I' sure that you will find more options.
Try this "key" to google:
Access vba code for conditional format