JHB, Thank you for this, it works quite wonderfully on Load to change the color.
I am wondering though, if there is a way to limit the records that it looks at upon opening. The reason being is that our production DB is a split DB with 5 users concurrently using. Our network isn't the best in...
Sorry, I should have been more clear in my original post and posted all of the rules in the first posting, that is my bad. I will clarify here:
On the main form we have two subforms. The top form ('subContactsForm') is a continuous form that tracks the 'people' calling into our service. The...
Hi,
I am tried for a while to get this working, using the skills I have but have not had luck.
Access 2010.
I am trying to conditionally format a control based on DateDiff if a person has called me back. The control to be formatted is in my main subform, but need to reference a value in...