By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Limiting the number of Subform records using MS Access 2003

P: n/a
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

Nov 15 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.