Put the following code in the form's AfterUpdate event:

If (DCount("*","NameOfYourTable") Mod 10) = 0 Then
MsgBox "10 Records have Now Been Entered Since Last Analysis"
End If

Steve



"thewabit via AccessMonster.com" u57141@uwe wrote in message
news:a34f819d2acbe@uwe...
Maybe it would be easier to explain what I want to do. I want to analyse
every 10 ten records as a set. So I need an easy way for the end user to
be
reminded when the "10th" one or "20th" one has been entered without having
to
go into the table and be on the look out for it.

John W. Vinson wrote:
Is it possible to have a message or a flag of somesort pop up when a
specific
numbered record is entered? Say I want something to happen after record #
10
is entered.

thanks

What do *YOU* mean by the "record number"? Are you counting records, or
waiting for the (meaningless, arbitrary) autonumber value, or what?

Bear in mind that "record number" is not a native concept within an Access
table.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1