AfterUpdate Event for a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an "Add New User" form which is used to input data about new users.
On clicking the "add User" button on this form, the data in the form is
entered into the "Users" table.

This "Add New User" form can be opened from various other forms, (for
example, a "loanEquipment" form). What I want to do is to update the user
list in, for example, the "loanEquipment" form. I do this with the requery
method.

I would like this requery method to fire when the "Users" table has been
updated. In the "loanEquipment" form, can I use the AfterUpdate property
referenced to a table ? Or am I barking up the wrong tree?

Many thanks
 
Tables don't have events, at least none that are exposed to us via VBA. What
I usually do in this type of situation is to pass the name of the calling
form to the called form using the OpenArgs argument of the OpenForm method.
The called form can then check its OpenArgs property to determine which form
called it and therefore which form needs to be requeried.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top