Conditiional Formatting: Any way to get down to get behind the scene?

[(PeteCresswell)]

I've got a subform where the field's conditional formatting would
be expressed in VBA as:
-----------------------------------------
If [IsApproved]=False Then
.ForeColor=255 (red)
.BackColor=15329769 (lite gray)
End If
-----------------------------------------

But I'd like to take it further and say that
if I've got .Locked=False for the field in question,
..BackColor=(white).... Giving the user a visual
acknowledgement that the form is in "Edit" mode.

So, bottom line, is there anyplace where I can fine-tune/supplement conditional
formatting?

 

[(PeteCresswell)]

Per (PeteCresswell):

-----------------------------------------
If [IsApproved]=False Then
.ForeColor=255 (red)
.BackColor=15329769 (lite gray)
End If
-----------------------------------------

But I'd like to take it further and say that
if I've got .Locked=False for the field in question,
.BackColor=(white).... Giving the user a visual
acknowledgement that the form is in "Edit" mode.

Oops! Got it. The magic word is "Me."

viz

 

[(PeteCresswell)]

Per (PeteCresswell):

Oops! Got it. The magic word is "Me."

viz

Oops... again...

Seemed to work until I tried to get cute and add another condition

Viz:
-----------------------------------------
[IsApproved]=False And Me.Locked=True (.BackColor=gray)
[IsApproved]=False And Me.Locked=False (.BackColor=white)
-----------------------------------------

Then it all stopped working until I went back to
a single "[IsApproved]=False"....

i.e. the compound logic stopped working altogether.

Anybody been here?