Write field to table when opened

[jibb]

Hello,

I have a database that uses a field from the last record to populate the primary key field on the current form. The database is used by several users simultaneously and I have been having problems with primary key conflicts. How can I write that field to the table as soon as the form is opened?

Any ideas will be good - its causing a fair bit of grief!

 

[gemma-the-husky]

rethink the idea.

why should a previous record have any impact on this record?

can you provide more information about what you are doing.

 

[jibb]

The primary key on the current record is a calculation from the last record on the table. It works fine until 2 people use it at the same time, then it start trying to duplicate the primary key.