Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Limiting the number of subform records
I am using the following code in a subform to limit the number of enteries: form_beforeInsert event: If Me.Recordset.RecordCount = 3 Then MsgBox "Maximum 3 line items can be entered!" Cancel = True End If Now what I want is to replace the "3" with an user inputed value...- AKBirder
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Limiting the number of records in a subform.
In the "else" statement, what is "LineNumber"? Access gives me a debugger error on this line. Also, there will be instances where the [count] will not be simply the number 3, it will be whatever value was entered in the main form under [count]. Can I still use this code but replace the =...- AKBirder
- Post #7
- Forum: Microsoft: Access Forms
-
Limiting the number of records in a subform.
Thanks seaport... that got me part of the way. Ultimately though, what i want Access to do is AUTOMATICALLY populate those records with the numbers 1, 2 and 3. I dont want the user to be able to mess with these. With the code you sent, they still have to enter the numbers into the subform...- AKBirder
- Post #5
- Forum: Microsoft: Access Forms
-
Limiting the number of records in a subform.
I have a subform (frm_SUB) within a form (frm_MAIN). On my main form I have a field ([Count])that requires the user to enter a number. (frm_SUB) and (frm_MAIN) are linked by a common ID. What I want to happen is for the subform (set up in data sheet view) to generate, automatically, the number...- AKBirder
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
