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 another subform on the main form.
Currently I can do a plain DateDiff of 10 days on the field, but want to do an expression to only color the control if a person hasn't called us back in 10 days - so taking a value from a subform and applying it to the expression if the checkbox is ticked.
I have attached a stripped down version for you to view.
when the database opens, it autoloads the form IntakeLog which is where I am trying to do the conditional formatting. The entry to view is First Name: Some and LastName: Person. When you select them you will see below the call notes where it explains a bit of what I am looking for.
(Any VBA errors are probably related to the other tables/forms/queries I removed to make the file small to upload - i think I resolved them all though)
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 another subform on the main form.
Currently I can do a plain DateDiff of 10 days on the field, but want to do an expression to only color the control if a person hasn't called us back in 10 days - so taking a value from a subform and applying it to the expression if the checkbox is ticked.
I have attached a stripped down version for you to view.
when the database opens, it autoloads the form IntakeLog which is where I am trying to do the conditional formatting. The entry to view is First Name: Some and LastName: Person. When you select them you will see below the call notes where it explains a bit of what I am looking for.
(Any VBA errors are probably related to the other tables/forms/queries I removed to make the file small to upload - i think I resolved them all though)
Conditional Formatting: DateDiff date based on subform date values: Access 2010
0 commentaires:
Enregistrer un commentaire