dLookup Conditional Formatting

[Guest]

Is there a way to apply conditional formatting using data stored in another
table?

I want the different schools I work with to set their own parameters on what
constitutes a warning or an infraction. Some schools allow students to be
tardy 10 times to class before disciplinary action is taken. Others only
allow 5.

I have conditional formatting on a field, TardyCounter, in a subForm,
subTardyCounter, that counts the number of times a student was tardy. I
would like to have the schools enter a number in tblExtraInfo.warning and
tblExtraInfo.disciplne and use those fields in conditional formatting.

If TardyCounter <= tblExtraInfo.warning then blah blah blah
If TardyCounter is Between tblExtraInfo.warning AND tblExtraInfo.discipline
blah...
If TardyCounter >=tblExtraInfo.discipline then blah blah blah


Anyone every do that before and have it work?

 

[Marshall Barton]

Is there a way to apply conditional formatting using data stored in another
table?

I want the different schools I work with to set their own parameters on what
constitutes a warning or an infraction. Some schools allow students to be
tardy 10 times to class before disciplinary action is taken. Others only
allow 5.

I have conditional formatting on a field, TardyCounter, in a subForm,
subTardyCounter, that counts the number of times a student was tardy. I
would like to have the schools enter a number in tblExtraInfo.warning and
tblExtraInfo.disciplne and use those fields in conditional formatting.

If TardyCounter <= tblExtraInfo.warning then blah blah blah
If TardyCounter is Between tblExtraInfo.warning AND tblExtraInfo.discipline
blah...
If TardyCounter >=tblExtraInfo.discipline then blah blah blah

Use a query for the subform's record source. The query will
need to Join the tardy table to tblExtraInfo on the schoolID
field and include the warning and disciplne fields. This
way all the information required for CF will be available to
do what you want.