Help with SQL Statement

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
FROM tblHeuristics
WHERE (((tblHeuristics.SuggestedAskAmount)=[Me].[subfrmHeuristics].[Form].[cboAskAmount].[Value]));

Select allOpen in new window