I need help with an Update SQL for a form, which also contains a subform. Once a record is saved in tblContacts, I would like to create a corresponding record in tblHeuristics that has the Contact ID saved as the as the foreign key as well as the value of a control named "cboAskAmount" whose record source is [SuggestedAskAmount] the code I have written below doesn't work, which doesn't surprise me since I am new to VBA. Can anyone help?
INSERT INTO tblheuristics ( fk_ContactID, SuggestedAskAmount )
SELECT tblHeuristics.fk_ContactID, tblHeuristics.SuggestedAskAmount