troubleshooting Question

Write a record to a table by double-clicking a record selector in a datasheet form

Avatar of SteveL13
SteveL13Flag for United States of America asked on
Microsoft Access
2 Comments1 Solution62 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros