SteveL13
asked on
Write a record to a table by double-clicking a record selector in a datasheet form
I am trying to write a record to a table by double-clicking a record selector in a datasheet form. But for some reason it is only writing the first record in the list rather that the one I am double-clicking on. Here is the SQL of the append table query: (Can someone tell me what I'm doing wrong?)
INSERT INTO tblCustomerAutoNotes ( Document, [Section], NoteCopyDD, NoteCopy, ForeColor, CustomerID, CustAutoNote )
SELECT tblEstimateNotes.Document, tblEstimateNotes.Section, tblEstimateNotes.NoteCopyDD, tblEstimateNotes.NoteCopy, tblEstimateNotes.ForeColor, [Forms]![frmEstimates]![cboCustomerID] AS CustomerID, tblEstimateNotes.CustAutoNote
FROM tblEstimateNotes
WHERE (((tblEstimateNotes.NotesID)=[Forms]![frmEstimates].[Form]![frmEstimateNotes].[Form]![txtNotesID]));
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER