Limiting the number of Subform records using MS Access 2003

[jmarr02s]

Is it possible to limit the number of Subform records using MS Access
2003?

That is, my end users want the capability of entering up to 12 records
on their subform.

Is that possible?

Thanks!,

jmarr02s

[salad]

jmarr02s wrote:

Is it possible to limit the number of Subform records using MS Access
2003?

That is, my end users want the capability of entering up to 12 records
on their subform.

Is that possible?

Thanks!,

jmarr02s

I put into a the GotFocus of the first field on a data entry form (the
field name is N) the following
Private Sub N_GotFocus()
If Me.RecordsetClone.RecordCount = 12 Then
MsgBox "Can't add more records"
DoCmd.GoToRecord acDataForm, Me.name, acLast
End If
End Sub