On Mon, 24 May 2010 12:52:04 -0700, Mommybear
wrote:

No VBA required, just a look at "Conditional Formatting".

-Tom.
Microsoft Access MVP


I have a form that is populated from a query using several tables. In the
detail section I have the following fields:

Category Code qty PO number ... .... ...

The qty is populated in the query based on whether or not a PO number is
available. If the PO number is not available then it comes from table a, if
it is available then it comes from table b.

On the form, I have my fields color-coded for easy reading. I would like to
be able to color the border and column heading based on where this value
comes from. If table A, then it is blue, if table b then it is red and
blocked from being updated (Locked = Yes).

Is this possible to do and if so How? If VBA coding is involved, please
spell it out for me as I'm still learning this. Thank you.