Update Table Field after update in another form

[theinviter]

Dears;

I want a way to Update a field in a table after the user click on check mark in the form.
so I have Check mark Named ( Qny_HQ) in table (MRN) which has a (item_code) and (Location_Code).
and when the user open Response form and click on Check mark (Aknwledge) want to update the check mark (Qnty_HQ) in MRN table.

can you advice me.

 

[Pat Hartman]

The obvious answer is to use an update query assuming the record exists in the other table. However, storing the same data in multiple places is generally wrong and you probably need to rethink your design.

Also, rather than using a checkmark to log a response, it makes more sense to either use a date time field to log when the response was made or perhaps a UserID to log who made the response. OR, maybe both - but NOT in two tables. Use a query that joins the two tables to obtain the information needed.