Fordraiders
asked on
subform to allow only five records
Access 2010 vba:
I'm trying to limit the numbers of records to enter into a subform.
The forms main "current event".
I have:
But I never get prompted to stop any data entry beyond 5 records ?
Thanks
fordraiders
I'm trying to limit the numbers of records to enter into a subform.
The forms main "current event".
I have:
With Me![dbo_t_redbook_pricing_escalation_detail_subform].Form
If .Recordset.RecordCount <= 5 Then
.AllowAdditions = True
.AllowEdits = True
Else
.AllowAdditions = False
.AllowEdits = True
End If
End With
But I never get prompted to stop any data entry beyond 5 records ?
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanx very much !
You are welcome!
/gustav
/gustav
ASKER
Open in new window
Called by
LimitRecords Me, 5
But Just need some stop message when trying to enter a 6th record. Or Some Alert.
Thanks
fordraiders