Conditional Formating based on another field (1 Viewer)

cktcPeterson

Member
Local time
Today, 00:13
Joined
Mar 23, 2022
Messages
73
I have a field on a subform
[frmApproveApplication].Form![KnikTribeMember]
if the field is "Yes"
Then I want [ProfileName] to have red text.

I tried conditional formatting, but not exactly sure on the expression.
 

June7

AWF VIP
Local time
Today, 00:13
Joined
Mar 9, 2014
Messages
5,472
frmApproveApplication is name of subform container control? I always name control different form object it holds, like ctrApp.

ProfileName textbox is on same form as KnikTribeMember? Assuming KnikTribeMember is a yes/no field, could simply be:

Expression is: [KnikTribeMember]
 

Users who are viewing this thread

Top Bottom