table update event

[Tony]

Hi,

In a form, when I modify some data and move to the next record, I want
be able to trap an event and do a query to check on the change done to
the table. Currently, I use the form After Update event, but when I do
a query, the table is not updated yet. Is there another event that
fires after the data is updated?

Similarly, if I delete a record from a form, I want to trap an event
and do a query to count how many records I have left in the table. Is
there a way to do this?

Thanks,

Tony

[Gabriele Bertolucci]

> In a form, when I modify some data and move to the next record, I want

be able to trap an event and do a query to check on the change done to
the table. Currently, I use the form After Update event, but when I do
a query, the table is not updated yet. Is there another event that
fires after the data is updated?
No, there isn't.

Form_AfterUpdate is what you need.

I've tested before replying and I can confirm that record has received the
modification when Form_AfterUpdate event is fired.
Similarly, if I delete a record from a form, I want to trap an event
and do a query to count how many records I have left in the table. Is
there a way to do this?

You can continue to use Form_AfterUpdate.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution