Scoring query

[kentendresen]

I have this scoring query which compares a given answer with an actual answer (multiple choice test).

IIf Actual Answer = Given Answer AS Correct and so on....
(The whole query is made by Mile O Phile)

Is it possible to link this Correct data to the form? If the answer is right and the Correct becomes 1, then a green box or something will be active, and if it is wrong (0), then another red box gets active?

Better solutions out there maybe?

Regards, Rookie Kent

 

[bjackson]

you could use conditionally formatting for that field if it
appears on your form.you can set up to 3 different formats
depending on the value of the field