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!!!!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
DLookup and Nz 0
Change Checkbox based on criteria entered in other fields 6
How to get a value from a related record? 13
Excel Staff Grade and Shift 0
database setup 1
identify employees that have/haven't taken certain training course 2
Gradebook Databse Setup 4

Back
Top