Re: limit record on continous subform



it is working perfectly on an edit mode of the subform but when i added new
record on my main form
my sub cannot add record
please help

thanks arvin

Arvin Meyer [MVP] wrote:
So copy and paste this exact code into your subform's code window and
compile the code (Debug >>> Compile):

Private Sub Form_Current()
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
If rst.RecordCount > 8 Then
Me.DefaultEditing = 4
Else
Me.DefaultEditing = 2
End If
End Sub

If you get any error, you may have to set a reference to DAO. Do that by
going to Tools >>> References and finding Microsoft DAO 3.6 Object Library.
Check the box next to it and everything should work fine.
thanks for the immediate response

[quoted text clipped - 15 lines]

how can i limit a number of record in a continous subform

--
" So be it"

Message posted via http://www.accessmonster.com

.