I have a continuous form, and there's a button on it that runs some VBA code. The code takes information that's in the detail area of the form and writes it to a table.
There will be some records on the form that will be ignored -- every record will not have data that gets written to the aforementioned table. For the records that do, I would like to have the background color of one of the fields in the detail area of the form changed to blue.
The way I have thinking about it is, after the code runs that writes the data to the table, I could then do the following:
Loop through each record on the continuous form and do this:
If the ScoreRecorded field = True then make the background color of the Points field blue.
ScoreRecorded is a field of type YES/NO.
I have tried to figure out how to do this, but I can't seem to get it. I found a post on StackOverflow that talks about using Me.Detail.Controls, but I can't figure out how to make sense of it.
Any ideas on the best way to do this?
There will be some records on the form that will be ignored -- every record will not have data that gets written to the aforementioned table. For the records that do, I would like to have the background color of one of the fields in the detail area of the form changed to blue.
The way I have thinking about it is, after the code runs that writes the data to the table, I could then do the following:
Loop through each record on the continuous form and do this:
If the ScoreRecorded field = True then make the background color of the Points field blue.
ScoreRecorded is a field of type YES/NO.
I have tried to figure out how to do this, but I can't seem to get it. I found a post on StackOverflow that talks about using Me.Detail.Controls, but I can't figure out how to make sense of it.
Any ideas on the best way to do this?