Add Entry from combobox code giving error messages

[KeithIT]

I am working with SJ McAbney's post on updating a table using a combo box when the entry is not in the list. However, each time I try to add a new entry I get an error message that I am creating a duplicate value in the primary key or index. yet the value is added to the table which the combo box's query (rowsource) pulls from.

The combo box is on a tabbed form (shows up on all pages) and has a control source which is a different query that also pulls from that table (has more information and is sorted differently, hence the two queries).

If anyone could provide me with some help finding an answer to this I would really appreciate it. I have searched MSDN and MS Knowledgebase as well as a general google search but have only come up with code for accomplishing the addition, not any suggestions for this error.

I am using Access 2002 and Windows 2000 sp4. Thanks!

 

[KeithIT]

Found Answer

I had the wrong set up in my combo box's row source. I set it to only one of the two fields that needed to be updated in the recordset, not both. Chalk it up to being sick (or stupidity... either one really...)