Controlling the Number of Entered Records in a Subform

[instructorgirl]

I have a main form called frmShipping and a subform called frmUnits. I want to control how many units can be entered into the subform for a given shipping record, i.e. from 1 to 7. I don't want them to be allowed to enter more than seven records. Do I need to do this with a query in the subform or is there a property that I can set? Any help would be greatly appreciated. Thanks!

 

[PHV]

In the Current event procedure of frmUnits (typed, untested):
Me.AllowAdditions = (Me.RecordsetClone.RecordCount - Me.NewRecord) < 7


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[instructorgirl]

Thank you so much. It worked perfectly!