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

I

ItsBarbara

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.
 
K

Klatuu

Once again, Barbara, you need to provide more detail.
The basics of it would be:

Me.chkFailure = Me.Grade1 < 70
 
I

ItsBarbara

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!!!!!
 

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

Split form 0
How to get a value from a related record? 19
Change Checkbox based on criteria entered in other fields 6
database setup 1
Looking for Formula 1
identify employees that have/haven't taken certain training course 2
Rank Query With Groups (Array?) 2
Populate Combo Box based on multiple text fields 5

Top