Limited sub records to 5 records only

N

New_Project

Hi all,
I have a form with a subform in it.
I want the records in the subform that relating to the
main form is limited to 5 records only.Usually when we
working with a continuos subform,when we are editing
the first record the second blank new records will show
up.And I want when the user is working at the fifth record,
the sixth blank new record will not showing up.
Is it possible?How to do it?
 
S

Steve Schapel

New Project,

I didn't test, but I think this should work, on the After Update event
of the subform:
Me.AllowAdditions = (Me.RecordsetClone.RecordCount < 5)

You may need something equivalent on the main form's Current event too.
 

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

Subform with no records 8
Form records 6
Access Main form/Subform Navigation 0
Uncontrollable subform records 3
Bound combobox only working on certain records 1
Testing Subform Records to make button visible 1
First Subform record gets modified when closing form 3
must have 2 records in subform 9

Top