Only allowing a record to be entered a certain number of times.

[liamfrancis2013]

Does anyone know a way to only allow a record to be entered a certain number of times, i need this for a school system where only a certain amount of students can be attending a class e.g a maxinum of 30 in period 1 art. Preferably some simple solution. Thanks



P.S right now i do have queries that have counted the number of students in a lesson using a iff if that helps

[ranman256]

when you click the ADD button to add the person, it does a check

sub Add1Person (pvStudentID, pvClassID)
dim iCount as integer , iLimit as integer
 
 'get the count for current class
iCount = dcount("[studentID]","tClass","[classID]=" & pvClassID)

'and the limit
iLimit= dlookup("[Limit]","tClass","[classID]=" & pvClassID)   'whereever you stored your class limits

if iCount+1 <= iLimit then 
    'add the student to class
endif
end sub