ftao milophile: re: allowing updating (1 Viewer)

[Pharcyde]

Mil-o-Phile answered the original for me, but i got a lil confused.

Hi all.

I have a query linking 2 tables: Student data & Student Assessments.

For eachstudent, I would like to count the number of assessments they have passed (using dcount).
Then, if they have passed all three i would like the (yes/no) accredited tickbox to be enabled.
In other words it can only be ticked if they have passed three assessments...

--((Instead of entering the student ID number, I'd just like it to run through them automatically and count them))--

Also, some notification that all assessment have been passed, like maybe a label that appears once a condition has been met?

How would i go about doing this??

P.S: Whats the '' [Me].[cboStudents]'' but about?

 

[Mile-O]

Whats the '' [Me].[cboStudents]'' but about?

As I prefer to use code it's a piece of code that refers to the current form and a combobox called cboStudents.

I did say i.e. above the example to demostrate it was only an example.

To calculate the number of assessments someone has taken then use the DCount using the Student's ID as the criteria.

For counting specific tests you'll need to use multiple criteria in your DCount()

i.e

DCount("[AssessmentID]","tblStudentsToAssessments", "[StudentID] = " & Me.cboStudents & " AND [AssessmentID] = " & Me.cboAssessment)