Conditional Formatting Issue

[RachelBedi]

I have a form (frmActivators) with several tabs (frmActivatorFreshLeads, frmActivatorBacklog, frmActivatorW9, frmActivatorSuspended, frmActivatorActivated, frmIndAudits) - one tab (frmIndAudits) has three more subforms as tabs(frmIndUnresolvedAudit, frmIndResolvedAudit, frmIndReportedAudit). I'm trying to apply conditional formatting to one particular field in frmUnresolvedAudit based on the value of another field (AuditSource) in the same form.

Here's what I have tried;

in Datasheet View;

Expression; [Forms]![frmActivators]![frmIndAudits]![frmIndUnresolvedAudit]![AuditSource]=[InternalQC]



also;

Expression; [AuditSource]=[InternalQC]

Continuous Forms View;

Expression; [Forms]![frmActivators]![frmIndAudits]![frmIndUnresolvedAudit]![AuditSource]=[InternalQC]

also;

Expression; [AuditSource]=[InternalQC]

Nothing seems to be working and it's driving me loopy, does anyone have a suggestion on what the heck I'm doing wrong?!

Thank you :-D

[June7]

How can a tab (frmIndAudits) have 3 subforms forms 'as tabs'?

The two values are on same subform? I tested that and it works in my db. I can't replicate the issue.

If you want to provide db for analysis, follow instructions at bottom of my post.