New Records are being deleted when other users add records

[carlp69]

I have a form that when you go into it creates a new record using the "DoCmd.GoToRecord , , acNewRec" in VBA
If I go into the form it creates a new record, say '1000'.
If another user goes in and creates a new record, say '1001' and then comes out of the form before me, my record 1000 disapears and i get the error message :-

Write conflict.
This record has been changed by another user since you started editing it. If you save the record, you will overwrite changes the other user made .........
"Save Record, Copy to Clipboard or drop changes" buttons

If I go in and create the record and come out before other users my record is created but others are lost.

I think it must be a locking problem, but cannot find a solution.

Any Ideas
Note - The data is stored on an sql server and is set up as an ADP

 

[hermanlaksko]

On the forms properties your should find an option "Record locks" (under "Data") try setting this to "Edited record"

Herman
Say no to macros