Which event fires? 1

[Eradic8or]

I have a ASP form that writes to a Access database.
On another machine, I have the database open at a form in datasheet view. By setting a timer to do a requery on the form, I can see when new records are enetered.

However, I want to do a sequence of events when this happens but I can't which event fires (if any) once a new record has been entered.

It doesn't work on the After Insert or After Update. This is presumably because it's not the form that's entering the data so what is the best method to detect that a new record has been added?

Hope this makes sense.

 

[RoyVidar]

No events fire if you update your data form outside the database. Access has no triggers. What you do now, utilizing the timer event, is probably the only way of trapping it, unless you consider manual requery;-)

Roy-Vidar

 

[Eradic8or]

Ok, thanks.
In that case, I will declare a static variable that does a record count on requery.
That way, when a new record has been entered, the value will change.