Conditional Forming Main form control based on Sub form control value?

sjd

Registered User.
Local time
Today, 14:31
Joined
Jun 19, 2012
Messages
34
I have form for entering jobs, which has several sub forms within tab controls. One of the sub forms, is an item entry form. This item entry form, has an obsolete check box, and a revision pending check box.

What I am trying to do, is change the color of input fields based on which check box is checked. (I have it working perfectly inside the sub form itself, but cannot get it to affect the main form.)

Is there a really easy way to figure out a controls "Full Path" eg. Me!Main!Sub!Form!Control ? (An un-editable control property perhaps?)

I am guessing 1 of 2 things is happening:

  1. My expression is wrong, getting it correct will make everything work fine.
  2. My expression is fine, but access hasn't loaded the sub-form, ergo conditional formatting fails. Would have to apply it after the sub-form loads?
Example Expressions:
[Me]![ItemMaster]![Form]![obsolete]=true
[Me]![ItemMaster]![Form]![obsolete]

obsolete is the checkbox control name.
ItemMaster is the sub-form control name.

Does the tab control effect the expression? (not based on what I have read, buy feel free to correct me!)
Do I need to use the sub-form name -- actual object/form name -- rather that its control name?
 
Just wanted to thank you. I had used the page linked above, but was using the incorrect VB reference. The format that finally worked was:

Forms!Mainform!Subform1.Form!ControlName
 

Users who are viewing this thread

Back
Top Bottom