Run a macro after a table is updated....

[wdp]

I am helping a very inexperienced user with a database issue and am hoping
there is a simple solution to the following:

The user will update a single tbl in a mdb.
Once the user completes the updates to the tbl, I'd like a macro to run to
populate additional tables with the new data.

Short of having the user click on the macro tab and run a macro, is there a
way to have the macro run automaticaly after the data entry tbl is closed?

I'm thinking the solution will involve a conditional macro but am not aware
of a macro fuction that is triggered by the close of a tbl (the close of the
file would work as well). Does anyone have any ideas?

wdp

 

[Steve Schapel]

Wdp,

The purpose of tables is data storage. Tables should generally never be
seen in normal production usage of a database, and should generally not be
used for data entry/editing, which is the purpose of forms. So in this
sense, your question is a bit odd.

Secondly, a core principle of database design is that any given piece of
data should only be stored one time, one place. So the need to "populate
additional tables with the new data" probably indicates a problem with the
table structure.

Can you give any specific example of the type of data you are copying?

 

[S.Clark]

Create a form. Trigger the macro from the Form's OnClose.

 

[Walt]

Thanks for the response, here's the info you requested:

Tbl1: Contains raw data (~100 fields, ~1000s of rows). Manually
updated by a few users WITH MINIMAL UNDERSTANDING of anything.
The data will probably first be compiled in .xls and then copied/
pasted into the tbl but may also be modified by manual editing. It
doesn't really matter, but a tbl normally works fine for them to do
this.

MANY queries will take the data from Tbl1 and reformat/modify it and
store it in a read-only tbl (Tbl2).
This tbl will be linked to potentially many different mdbs with users
with a broad range of access knowledge and needs for the tbl.

What I am looking for is to trigger the macros to run when the novice
user closes the file or closes the Tbl1 or something else so that they
don't have to physically double-click the macro.

If that can only be done using a form then I will look into that....

wdp