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.

On Mon, 24 May 2010 12:52:04 -0700, Mommybear
<(E-Mail Removed)> 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.