I have a mainform with an Object called [parttype’ and a subform form with an object called [DiscPL1] and need to do some conditional formatting on [DiscPL1] if [Partype] file’s value is like “Extended”.
I am using the “conditional formatting” function in MS Access 2007. Below is what I have that isn’t working.
IIF ([Forms]![frmMainForm]![[parttype] Like "Extended",[DiscPL1].BackColor = #ED1C24)
Could I please get help in getting the [DiscPL1] object to change the back color from blue to red if the condition is meet. thanks