Conditional formatting using a query w/in a subform-assoc'd amt fi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I'm using a query to display 2 fields (doc_type & amount) on my subform
within a Main form, how do I get the amount field to be highlighted using
conditional formatting? I got my doc_type field to be highlighted using
"Field Value is equal to Forms!frmContract!doc_type" but I do not know how to
get the associated amount field to also be formatted like the type field.
Please advise. Thanks!
 
gg said:
If I'm using a query to display 2 fields (doc_type & amount) on my subform
within a Main form, how do I get the amount field to be highlighted using
conditional formatting? I got my doc_type field to be highlighted using
"Field Value is equal to Forms!frmContract!doc_type" but I do not know how to
get the associated amount field to also be formatted like the type field.
Click to expand...


Not sure I understand your arrangement, but maybe you can
use the Expression Is option:

[doc_type] = Forms!frmContract!doc_type
 
Marshall,

I had just figured it out before seeing your response. You are correct!

I used the Expression Is option: [Forms]![frmContract]![doc_type] = [doc_type]

and it works perfectly.

Thank you for looking at this! Your help is always awesome!

Marshall Barton said:
gg said:
If I'm using a query to display 2 fields (doc_type & amount) on my subform
within a Main form, how do I get the amount field to be highlighted using
conditional formatting? I got my doc_type field to be highlighted using
"Field Value is equal to Forms!frmContract!doc_type" but I do not know how to
get the associated amount field to also be formatted like the type field.
Click to expand...


Not sure I understand your arrangement, but maybe you can
use the Expression Is option:

[doc_type] = Forms!frmContract!doc_type
Click to expand...
 
Back
Top