Set Yes/No field to Yes based on criteria in other fields

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

Guest

I have a grade database and want to have a Failure checkbox set to yes when a
grade is below 70 in any of the grade fields.
 
Once again, Barbara, you need to provide more detail.
The basics of it would be:

Me.chkFailure = Me.Grade1 < 70
 
I have a form with grades for 30 week, 33 week, and 36 week
If any of these three are grades below a 70 then I need a check mark in the
Failures box.

I know I can do this with a query, but I am trying to create an automated
solution so that the Curriculum AP can just open a form and the checkmarks
are there if there are any failures listed

Hmmmmmmmm.....In typing this, I just realized. I can add that code to the
open event on the form because the query behind the form opens only those
students with any failing Grades.

Thanks!!!!!
 
Back
Top