records

  • Thread starter Thread starter pat
  • Start date Start date
P

pat

how do i prevent more than 'x' number of new records
being added to a table based on having that table within
a subform.
 
how do i prevent more than 'x' number of new records
being added to a table based on having that table within
a subform.
Click to expand...

You'll need some VBA code to do this. In the Subform's BeforeInsert
event you could put code like

Private Sub Form_BeforeInsert(Cancel as Integer)
If DCount("*", "[tblChild]", "[LinkField] = " & [LinkField]) > 10 Then
MsgBox "Only ten records are allowed"
Cancel = True
End If
End Sub

John W. Vinson[MVP]
 
Back
Top