Limiting record in a continous form 1

[kpryan]

Hi all,

I have a form which has a sub form inserted. I want a user to be able to input data to just 4 records only.
The reason for this is that the sub form provides data for an invoice for extra items. Is needs to be limited because the invoice report has to have a lot of medical data. So that there is only enough room for 4 records to be printed. I have used 7 pt text to accommodate this. 4 records is about all that is required anyway. Is it possible to limit on the sub form for just 4 records.

Many thanks,

KP

 

[PHV]

In the Current event procedure of the subform:
If Me.NewRecord And Me.RecordSet.Count > 4 Then
Me.UnDo
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886