I have a form which users use to enter records. For each person filling out the form they are "assigned" a userID automatically which is a text ID. The table also of course has a RecordID autonumber field.
Anyway, as the user is filling out the form, which is really a sub-form (continuous form), and have entered 5 records and attempt to enter a 6th record, I want a message to popup informing them that they can't enter any more records.
Something like this but I don't know how to qualify the userID:
Private sub Form_BeforeInsert(Cancel as Integer)
If Me.txtCount > 5 Then
Cancel = True
Msgbox "Please return a book before checking out a new one", vbOKOnly