Conditional format based on value in parent form



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

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?


Ken Snell \(MVP\)

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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question