Updating data from one table to another

[Bill4tektips]

I'm having a problem updating one table to another. The scenario is this: I have two tables "tblConductAudit" and "tblConductAuditDetails" Both of which have a field name "ExecutiveSummary". "frmConductAudit" is my main form where the information is displayed and I have Buttons on the form to open up separate forms (Which are only larger versions of the field boxes to let people see more data which they are inputing as the field boxes in "frmConductAudit" are rather small owing to the amount of information required),these are in table "tblConductAuditDetails" and I am trying to get "tblConductAuditDetails" to update the amended text in "tblConductAudit" through an update query but I am having no luck. Can anyone help?

 

[Remou]

It is always a good idea to post any SQL you are having problems with.