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]

Re: table update event

> In a form, when I modify some data and move to the next record, I want[color=blue]
> 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?[/color]

No, there isn't.

Form_AfterUpdat e is what you need.

I've tested before replying and I can confirm that record has received the
modification when Form_AfterUpdat e event is fired.
[color=blue]
> 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?[/color]

You can continue to use Form_AfterUpdat e.

--
PBsoft di Gabriele Bertolucci

https://www.pbsoft.it

skype: pbsoftsolution