Use VBA to update another table

[mavisyew]

Hi All,

I have created a form with a field status for the table named, tblHistory.


I will like to update another table, tblCaseDetail, Status field when i click Save in the form.

What is the code i should write to update to the tblCaseDetail's status field in the private sub AfterUpdate?

Thanks in advance.

[mavisyew]

Hi All,

I did it.

I add in the below code to my afterupdate


DoCmd.RunSQL "UPDATE TBLCaseDetail" & _
" SET TBLCaseDetail.Status = """ & Me.Status & _
""" WHERE TBLCaseDetail.CaseID = """ & Forms![FormCaseHistory]![CaseID] & """"