Limited the number of records displayed in a datasheet

[Rob P]

Hi...

I am assigning 32 IP Addresses from a subnet to a particular ID. I have a
query to report unassigned IP addresses but want to limit the number of
records displayed in a subform (datasheet view) to 32 and no 65000+.


Is this possible???

Thanks

 

[Arvin Meyer [MVP]]

Sure, something like this should work:

Sub Form_BeforeInsert ( Cancel as Integer )
If Me!MySubForm.Form.RecordSetClone.RecordCount = 32 then
Msgbox "Only 32 records are allowed"
Cancel = True
Exit Sub
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access