Record counting

[peterbowles]

I am designing a DB for a go-Karting company

One request is that every 5 times a customer pays for a go they get a free go. they do not want to free go to be counted.

So to alert them of this

I want a txt box on the form that counts the records, (done this)

every 5 records a msg box pops up tells them the customer has a free go

a code is entered in the Race ID field (Like FG for free go) this record is not counted

Cheers

 

[llkhoutx]

Use the form OnTimer event and set the Timer Interval to 5000, i.e. 5 seconds.