I have an update query that I need to run on a cuurent and open record. I have two forms. The customer form and the deal deatail form. I need to update the Customer Name on the tbl_Deals. Here is what I have and I can't get it to run.
CurrentDb.Execute UPDATE tbl_Deals SET Legal_Name=Forms![frm_Customer]![Legal_Name] WHERE Deal_Rec_ID=Me!Deal_Rec_ID"