Form/query writing 2-rcds to table at form save

  • Thread starter Anthony G via AccessMonster.com
  • Start date
A

Anthony G via AccessMonster.com

I have a main form with a subform on it. when i save the record it saves 2-
records as though it's splitting the fields names. Below is my code:

SELECT tblPolicy.TxtFileNum, tblPolicy.FileNum, tblPolicy.Desc, tblPolicy.
RelToReg, tblPolicy.DtOfOrigNotice, tblPolicy.PC, tblPolicy.ActionReq,
tblPolicy.Responsibility, tblPolicy.PersonsNotified, tblPolicy.DueDt
FROM tblHeader INNER JOIN tblPolicy ON tblHeader.FileNum = tblPolicy.FileNum;

I'd like it to save the header records to the tblHeader and the policy
records to the tblPolicy table, but the tblPolicy is the one that has the 2-
records at time of save. one with the filenum and one record with the
filenum.

Thanks,
Anthony
 
Top