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.
being added to a table based on having that table within
a subform.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
how do i prevent more than 'x' number of new records
being added to a table based on having that table within
a subform.
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]