Conditional format based on value in parent form

  • Thread starter Thread starter TG(Denmark)
  • Start date Start date
T

TG(Denmark)

I have a form with severaveal subforms, and what I want is:

When a record is selected in one subform
Then the format of the corresponding records in another subform is
changed

I have a field in the parent form that hold the value (Sample_ID) to
compare, when the subform is loaded the conditional formatting works
fine, but when Sample_ID is change the conditional formatting does not
change ;-(

I have tried with subform.requery, but i does not help..

Any suggestions?

TG(DK)
 
You can reference a field on the main form from a subform this way:

[Parent].[NameOfControlOnMainForm]
 
Back
Top