I have a form called "Customers" with a subform called "Investments", the investments subform is based on the "Investments Query". I have 2 fields on the subform for incomes for Client 1 & Client 2. I wish to use conditional formatting to disable the client 2 field based on a relationship of "single" on the mainform. I successfully did this by putting the "relationship" field from "Customers" into the "Investments" query and set the formatting based on an expression for that field.
The problem emerges when I then try and use check boxes or option groups on the sub form. They all seem to be turned off andproduce no result when clicked on.
If I remove the "relationships" field from the query they work again.
I can't work out why this is happening. Any suggestions?
If I can't set it up this way is there a expression i can use on my subform to reference the field on the mainform?
I have tried "[Forms]![Customers]![relationships]=1" but this produces no result. Any thoughts please?
The problem emerges when I then try and use check boxes or option groups on the sub form. They all seem to be turned off andproduce no result when clicked on.
If I remove the "relationships" field from the query they work again.
I can't work out why this is happening. Any suggestions?
If I can't set it up this way is there a expression i can use on my subform to reference the field on the mainform?
I have tried "[Forms]![Customers]![relationships]=1" but this produces no result. Any thoughts please?
