Limit Number of Records

A

Allen Browne

Use the BeforeInsert event procedure of your subform.
Cancel the event if there are already too many records.

If this is important, you might want to DCount() the relevant records in the
subform's table rather than just read Me.RecordsetClone.RecordCount.
 
A

Arvin Meyer [MVP]

Pookey said:
How do you limit the number of records you have in a subform?
Click to expand...

Try using the recordcount property of the subform's
recordset in the subform's Current event.

For 5 records you would do something like:

Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone

If rst.RecordCount >= 5 Then
Me.DefaultEditing = 4
Else
Me.DefaultEditing = 2
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I limit the number of records in a table, not a query? 4
Limit number of records returned from query 5
Number of Records 3
how to limit the record number 2
I Want to Limit 4
Recordsource for subforms 2
How can I limit Access query to 65000 records 4
limit of records 4

Top