If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 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) |
#2
|
|||
|
|||
Conditional format based on value in parent form
You can reference a field on the main form from a subform this way:
[Parent].[NameOfControlOnMainForm] -- Ken Snell MS ACCESS MVP "TG(Denmark)" wrote in message ... 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) |
Thread Tools | |
Display Modes | |
|
|