C Confused Slug Sep 29, 2009 #1 How / can you limit the number of records that may be entered into a sub form in datasheet view to say 20? Thanks Confused
How / can you limit the number of records that may be entered into a sub form in datasheet view to say 20? Thanks Confused
T Tom Lake Sep 29, 2009 #2 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
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
D Dirk Goldgar Sep 29, 2009 #3 Confused Slug said: How / can you limit the number of records that may be entered into a sub form in datasheet view to say 20? Click to expand... See this page on my website: http://datagnostics.com/dtips/limitentries.html Limit the Number of Entries on a Continuous Form
Confused Slug said: How / can you limit the number of records that may be entered into a sub form in datasheet view to say 20? Click to expand... See this page on my website: http://datagnostics.com/dtips/limitentries.html Limit the Number of Entries on a Continuous Form
