INSERT INTO Question

[ph74]

I am using the following INSERT INTO statement, to insert a users RecordID and a CourseID (CSID)into the training table,

strInsert = "INSERT INTO training (RecordID, CSID)" & "Values ([RecordID], '" & cboSchedule & "')"
DoCmd.RunSQL strInsert

The problem being, if there is not already an entry in the training table with a RecordID and CSID, then INSERT INTO does not insert anything and does not give any errors.

Any help appreciated.

Paul.

 

[lupins46]

strInsert = "INSERT INTO training (RecordID, CSID)" & "Values (" & me.[RecordID] & ", '" & me.cboSchedule & "')"