Record Limit

C

Confused Slug

How / can you limit the number of records that may be entered into a sub form
in datasheet view to say 20?

Thanks
Confused
 
A

AccessVandal via AccessMonster.com

There is a way to limit the recordsource query in your form by TOP 20 but I
believe that's not what you want.

Are you saying limit the number of entry/input to the subform so that it does
not exceed 20 records?

One way you can do it in the subform's current event.

Dim rs As DAO.Recordset

Set rs = Me.RecordSetClone

If rs.recordcount = 20 then
me.AllowAddition = False 'disable data entry
End if
Set rs = Nothing
 
T

Tom Lake

Are you saying limit the number of entry/input to the subform so that it
does
not exceed 20 records?

One way you can do it in the subform's current event.

Dim rs As DAO.Recordset

Set rs = Me.RecordSetClone

If rs.recordcount = 20 then
me.AllowAddition = False 'disable data entry
Click to expand...

One small thing: That should be

Me.AllowAdditions = False 'disable data entry

Tom Lake
 
Top