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:
[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?
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:
- My expression is wrong, getting it correct will make everything work fine.
- 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?
[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?