Table grabs extra record from form with unbound fields

[RetiredGuy]

Using DAO recordset, table enters unbound fields data properly for desired records, but adds an extra record which is a duplicate of the first record entered....any known access quirks for adding unwanted records? :banghead:

 

[JHB]

Are you sure the form is unbound, (- look at the Recordsource for the form)?
Else show you code for inserting data using the DAO recordset.

 

[RetiredGuy]

Thank you for your response....I was considering going to VB but tweaked my code to work in Access....the ghost record was code error.