We help IT Professionals succeed at work.

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

SteveL13
SteveL13 asked
on
60 Views
Last Modified: 2018-09-10
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]));

Open in new window

Comment
Watch Question

Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
You are correct.  It is a subform.  And thank you.