
Originally Posted by
rpeare
in the ON OPEN or ON LOAD event of the table, assuming the student count field is called fldStudentCount you could do this:
me.fldstudentcount = dcount("*", "tblStudentData")
if you want to count all records in tblStudentData (every record should have a last name so you shouldn't need to count last names)
if you do you can put criteria in the dcount function
me.fldstudentcount = dcount("*", "tblStudentData", "[StudentLastName] is not null")
I forget the syntax for null in domain functions but you get the idea.