change field based on data in related table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
I am using forms. I have a form with 2 subforms. I tried to do this with
conditional formatting, however,it didn't work.
 
Back
Top