Conditional formatting

[Tara]

I have a form that displays dates of service for specific clients. There are
times when we need to go back and adjust those dates after the service has
already been billed for. Since we've already billed for it, we have to keep
the original date too. So, I designed a second form to list amended dates
and any notes the user wants to add to explain why the date is being amended.
Currently there is a command button next to the original date that allows
the user to open the second form and add the amended dates and notes. The
data in each form is related through a ContactID number. The command button
has a colored rectangle around it. Is there a way to change the color of the
rectangle if amended data has indeed been added? Or can I change the
background of the textbox containing the original date of service so the user
knows that data has been amended?

 

[Larry Linson]

Forms don't store data; tables store data. If you describe your data, how
it's arranged in tables, and how the forms relate to the tables, perhaps
someone can offer a useful suggestion.

Larry Linson
Microsoft Office Access MVP