Conditional Formatting using a query on a Form

[Guest]

How do I use a field on a Parent form (frmContract!doc_type from the Contract
table) to determine the conditional formatting in a subform (QryTotal by
doc_type) based on a query (this query contains the summarized amount by the
same doc_type)? I'm trying to highlight the record where the doc_type field
is equal to the record that has the same doc_type.

I tried using Condition1-Expression Is Me!frmContract!doc_type = Me!qryTotal
by doc_type, but it is giving me an error msg: "The expression you entered
contains invalid syntax." Thank you!!!

geri

 

[Guest]

I got 1 field to work using the Condition1-Field Value is Equal to:
Forms!frmContract!doc_type; however, how would I get the associated amount
field that corresponds to its doc_type to also be highlighted? The query is
pulling 3 fields, one of which is the doc_type and amount fields.

Thank you!