Conditional Formatting in subreports

  • Thread starter Thread starter Perplexed
  • Start date Start date
P

Perplexed

Hi again,

My report is now working marvelously thanks to everyone's help. Now I would
like to have conditional formatting (bold & color) for the field [ApptDate]
in the subreport for appointments if the date is greater than the date in the
[FirstWarning] field in the Suspensions subreport. I've tried a couple of
the examples already posted but can't get it to work because each subreport
is based on separate queries which are joined by primary keys [CustomerID].

Thanks again for all your help -- you are all terrific!
 
You are going to be SOoooo proud of me. I figured it out all by myself.
Wasn't easy but kept looking for examples in the help files and through trial
and error I made changes to them and I finally got it to work. Here's what I
entered...

Field Value is greater than [Reports]![NO SHOW REPORT]![Suspension Query
Subreport]![FirstWarning]

Breakdown:
"Field Value" and "greater than" are selections from the conditional
formatting creiteria and the rest is:
[Reports] tells Access to look for a report
[NO SHOW REPORT] specifies which one (and is the main report)
[Suspension Query Subreport] which subreport on the main form
[FirstWarning] field to compare value to

set my formatting options and Eureka it works!

Hope my example helps someone else.

Take care!
 
Back
Top