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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: AKBirder
  • Content: Threads
  • Order by date
  1. AKBirder

    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...
  2. AKBirder

    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...

Part and Inventory Search

Back
Top