How to limit the subform records

's Computer Specifications

I want to put code to limit the number of records of subform.

I mean I want user to enter only 10 records in the subform.

Once the 10 record is entered, it will not allow any further entry/disable
to new entry.

Please advise a code or sample mdb to get this solution.

Regards

Irshad

's Computer Specifications

On the On Current Event of the sub form write the code

If Me.RecordsetClone.RecordCount >= 10 Then
Me.AllowAdditions = False
Else
Me.AllowAdditions = True
End If

--
Good Luck
BS"D

"Irshad Alam" wrote:

>
> I want to put code to limit the number of records of subform.
>
> I mean I want user to enter only 10 records in the subform.
>
> Once the 10 record is entered, it will not allow any further entry/disable
> to new entry.
>
> Please advise a code or sample mdb to get this solution.
>
> Regards
>
> Irshad

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
subform combo to filter based on other subform...technically mainform's other subform records.	nospam@thankyou.com	Microsoft Access	0	15th Sep 2006 07:51 PM
Urgent !!! - Values from Subform - #Error if no records in Subform and Only grabs first subform record	Greg	Microsoft Access Forms	0	17th Feb 2005 02:12 PM
how to limit records in subform??	=?Utf-8?B?TmF6cmll?=	Microsoft Access	1	21st Dec 2004 08:02 PM
Use Combo box to limit records when subform is based on query?	Steve C	Microsoft Access Forms	1	29th Jul 2004 04:35 AM
Limit Number of records in a Subform	Nick1966	Microsoft Access	1	27th May 2004 12:02 AM