change field based on data in related table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BarbaraM - 31 Jan 2007 04:05 GMT

I have data in a table which represents a student plan (Classes recommended)
Another Table contains the results of the plan (Classes taken and
passed/failed)
I want to be able to change the look of the field (fade the text, or change
the background) in the plan when the class is completed and passed.

Is there anyway to do this?

Reply to this Message

Mr B - 31 Jan 2007 04:22 GMT

BarbaraM,

You make it should as if you are attempting to accomplish these results in
the tables. You do not indicate that you are using any forms to view your
data.

Please note that you always want to use a form to display and manage your
data. The tables are only for storing the data. When using a form to view
and manage your data you will certainly be able to accomplish what you want
to do.

Signature

HTH

Mr B

> I have data in a table which represents a student plan (Classes recommended)
> Another Table contains the results of the plan (Classes taken and
[quoted text clipped - 3 lines]
>
> Is there anyway to do this?

Reply to this Message

BarbaraM - 31 Jan 2007 15:52 GMT

I am using forms. I have a form with 2 subforms. I tried to do this with
conditional formatting, however,it didn't work.

> BarbaraM,
>
[quoted text clipped - 15 lines]
> >
> > Is there anyway to do this?

Reply to this Message