Openrecordset issue and duplicate row insertion occuring

[Dave_D]

I have 2 issues. I have the following code.

Dim db As DAO.Database
Dim rstTemp As DAO.Recordset
Set db = CurrentDb
Set rstTemp = db.OpenRecordset("tbl_IssueList",adOpenDynamic)
'Set rstTemp = db.OpenRecordset("tbl_IssueList")

rstTemp.AddNew
rstTemp![Info Type] = Forms![New Issue]![Info Type]
rstTemp![Entry Date] = [Entry Date]
rstTemp![Auditor ID] = Forms![New Issue]!AuditorID
rstTemp!Topic = Topic
rstTemp!InfoQuestion = InfoQuestion
rstTemp.Update

Issue #1 - Whenever I try adding a TYPE (ex. adOpenDynaset) to my db.OpenRecordset SET statement, I get an error of "Invalid argument" Why is that?
Issue #2 - When I default using TYPE on my SET Statement (2nd one in the code), my table results in 2 entries.

tbl_IssueList
ID	Info Type	Entry Date	Auditor ID	Topic	InfoQuestion	Response Date	Response	Attachments
90		6/11/2018		Other	My Question			0
91	Question	6/11/2018	DGD001	Other	My Question			0

A. Why do I get 2 results?
B. Why does only the second entry contain all the data from the forms (NEW ISSUE) entry.

Both Info Type and Auditor ID are unbound.

Is there an alternative way to just get a single entry (ID 91) into my table?

Thank you and any help or suggestions would me appreciated!

[pbaldy]

If I had to guess, your form is bound to the table, so it's adding a new record in addition to the code. You want one or the other, not both. The argument normally used is dbOpenDynaset.

[Dave_D]

You were 100% correct and by changing a few to unbound, I managed to insert a single row. Thank you

[pbaldy]

Happy to help. For clarity, the form itself should be unbound, as well as the controls with it. That said, bound forms are easier to set up than unbound forms, and don't require code to save records.