Trigger Update Query

[wallis1905]

Hello All,
Help! Does anybody know if it's possibe to run an update query based on a trigger. For example every time somebody opens a certain table the update query will run?
I'm sure it must be easy.

 

[boblarson]

Access doesn't use triggers, but if you don't let your users open a table, but use a form instead (you can create a form and display in Datasheet mode that makes it LOOK like they have the table open) then you can use the form's Load or Open events to do something like you want.

 

[wallis1905]

Hi Bob,
We meet again! So does this mean that if data is entered through queries then your out of options?

 

[boblarson]

You betcha! Form's are the way to go as you have the control. Without them you don't have events and without events you can't tell Access what to do, when.

 

[wallis1905]

Boooo! Ok, Thanks anyway.