Conditional format based on value in parent form

[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)

 

[Ken Snell \(MVP\)]

You can reference a field on the main form from a subform this way:

[Parent].[NameOfControlOnMainForm]