Auto execution of macro

[Amod]

I have a macro for OpenQuery, my DB resides on network. Is there a way that I
run that macro whenever the condition gets true, i.e. whenever the table gets
updated.
Can anyone help me with auto execution of macro?

Thanks

 

[Steve Schapel]

Amod,

Probably need more information in order to give a good answer here. But
it sounds like you need to run the macro on the After Update event of
your data entry form.

 

[Amod]

Steve,
I have created a macro that executes a Update query whenever a new entry is
inserted in a table. Now I want to execute this macro from outside of this
database, since this DB resides on network.

Thanks

 

[Steve Schapel]

Amod,

Can you link to the applicable table in the database that you want to
update?

 

[Amod]

Link in the sense?
That Linked tabled(linked to Sharepoint list) is in the same database.
Now my problem has changed, if you see the post in the same group: autoexec
macro, dialog box pops up:
"I have created a autoexec macro that runs according to a task scheduler.
This
macro runs a query over a Linked table(linked to sharepoint list). now when
this scheduler open the access db, it gives me a dialog box specifying that
execution will affect the change in the lnked table(YES OR NO). Because this
macro will run on network server, its not possible to click yes all the time.
can you please suggest how can I click YES automatically through a macro or
this dialog box can be prevented from popping up. It does not come when i run
this macro for a query over a normal table."