Controlling the Number of Records in a Subform

[dgutsche]

Hello again!



I am trying to decide if this is a safe thing to do. I would like to lock the number of records in a sub form based upon the a field in a parent form. For instance, if the field box says 5 in the parent form I want exactly five records to be generated in the subform. I don't want the user to be able to add records without upping the field value from the main table. Is there a good way to do this - is it even a safe thing to do?

Thanks!

[burrina]

Don't understand the reasoning for this but yes it can be done. Example: Just add your criteria.

If Form.RecordsetClone.RecordCount > 5 Then
Cancel = True
End If

HTH

[dgutsche]

Okay that works, I should be able to tweak it by changing the 5 to reference the field in the parent form. I hope ha ha. I should be able to figure that out.

Thanks again burrina!