Multiple Users add new row in Table

[Lenny_821]

Hi,

I've got a database with multiple users. When they add a new row (using a form) it replaces another row that was just added by someone else. Very strange??

I use the following;
Set db = CurrentDb()
Set trs = db.OpenRecordset("FTE")
..... some code
trs.AddNew
trs.Fields("Source") = Combo_Source.Value
...... some more code
trs.Update

Set db = Nothing
Set trs = Nothing

How can I solve that problem?

Lenny

 

[FoFa]

Sounds like you are not getting a unique key for each add. Where is the primary key coming from?

 

[Lenny_821]

I think that must be the problem. I'll add a primary key. Thanks for the tip.

Lenny