Data Macro(After Update): For each on field a few tables removed

[mantooth29]

I need to create an AfterUpdate action that modifies records in another table.

However, I am not having success and I think its because the table I need to modify is on the other side of a junction table.

So AfterUpdate [tbl_Groups] needs to modify records in [tbl_Commitments] which both have foreign keys in [tbl_Reviews]

Is this possible with data macros?

I have pasted a picture of my macro if that helps visualize what I want to do. Right now no records are being modified after an update.

[June7]

The only ways I know to update field in another table is with an UPDATE query or VBA opening a recordset of the other table and editing the recordset.

[mantooth29]

The only ways I know to update field in another table is with an UPDATE query or VBA opening a recordset of the other table and editing the recordset.

Ah ok. I was trying to work off some examples from here

http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

but I see that they were editing records in the same table.

Do you know if I could trap the Record ID from the table with a trigger on it, then execute an update query with that key as a parameter?

[June7]

I think not but really need to know more about what you are trying to do.

Why do you have to do this edit?

[mantooth29]

Thanks for following up. It does not seem like I can accomplish what I wanted with a trigger, so I just built a query on the front end and will have it execute with Form Events. Thanks again!