Conditional formatting subform in datasheet view dependant on a parent form value

[Roosters]

Hi,

Is it possible to change the background colour of a single field in a sub form in datasheet view dependant on a value on the main form (using the menu option conditional formatting requires a set value that does not vary)
Any help would be really appreciated.

Thanks Phil

 

[Roosters]

Answered my own question - thanks anyway

 

[PHV]

Any chance you could post your solution for the benefit of the members ?

 

[Roosters]

Ended up using the menu (format - conditional formatting) Exception option, entered my expression pointing to the main form field that contained the varying value and it worked a treat.