This isn't possible in the tables themselves. Tables are basically just
buckets to hold your data. You shouldn't routinely be making entries
directly into the tables. Instead, you should be using forms for data entry.
On a form, you could use Conditional Formatting on the controls to change
the color as desired.
As far as checking the field in the other tables, you could do this
automatically through code. However, the real question is whether or not you
need those fields. Instead, there should be a relationship between those
tables and the table that you enter the date into. Once you have that, you
could use a query to access both tables at once and filter the query on the
records that have a date in the No Longer Managed field.
--
Wayne Morgan
MS Access MVP
"Christa Waggett" <3w****@ispdr.net.au> wrote in message
news:11**************@stitch.ispdr.net.au...
Hi, I'm not a programmer but would appreciate some help with the
following.
I've been looking at various sites but cannot find the information I
require.
I have a table of strata plans and if we no longer manage the plan the
date
this occurs gets entered into a field. What I would like to happen is for
all the fields in that record to change their forecolor to red as soon as
the DateLost field is no longer null.
I also have several related tables which have a tick box in them to say we
no longer manager the plan. At the same time that the above occurs I
would
like to update the related tables by having the tick box field entered and
the forecolors of these records also to change to red.
Is it possible to do this automatically? If yes, how?
Any advice would be greatly appreciated. Thanks,
--
Christa