Hello, I have a question about Access 2003, Can I create a trigger or something like that in Access 2003, if it's true, someone knows how to create it?

What Exactly I am looking for is
• One Database with multiple tables
• I need a trigger to Add/update a row/field in another Table, once a certain value is added/updated in the access table.

Need to know ASAP

step 1. write an update query for the required field

step 2. put the sql into the after update event of the required field in the form. If multiple fields put in verification code ahead to make sure both requirements are met.

have a look at beginning access 2003 vba for the requirements of the code and further examples