From: DSmith on 30 Apr 2010 13:27 I have a form with 2 datasheet subforms that linked by a payment ID field. If the payment does not equal 0 in the first subform, I'd like a field [Paid] in the second subform to turn red. This field is a check box so that might have to change. Is this even possible??
From: Tom Lake on 30 Apr 2010 13:44 "DSmith" <donna(a)DONTSPAMresxrn.com> wrote in message news:uUObspI6KHA.328(a)TK2MSFTNGP05.phx.gbl... > I have a form with 2 datasheet subforms that linked by a payment ID field. > > If the payment does not equal 0 in the first subform, I'd like a field [Paid] in the > second subform to turn red. This field is a check box so that might have to change. > > Is this even possible?? > Try looking up Conditional formatting. It might do what you want. Tom Lake
|
Pages: 1 Prev: Error on filtering data in a from Next: Referencing another field |