Count files (1 Viewer)

[wizcow]

I would like to have a message box pop up after 15 entrys have been made in the subform on my Invoice form.

How do I count the entrys on a subform?

Thanks
Tom

 

[RichO]

In the subform's AfterUpdate event you could use:

If Form.CurrentRecord = 16 Then
MsgBox "15 entries have been made", vbInformation
End If

 

[wizcow]

RichO

Thank you for the reply.

For some reason I was unable to make the

Form.CurrentRecord

work, but this works great...

Me.CurrentRecord

Thanks a bunch!

Tom