Hey!
I have an idea: Don't allocate the running number on form open-allocate the
running number on saving. You can do this with runningnumber = "select
max([Running Number]) from Table" + 1 (hope the syntax is correct). So you
have always the actual number. This also works in a network-client
database! I hope I help you - when you have problems, feel free to write!
Ps: Sorry for my bad english, I hope you know what I mean!
best wishes Philipp
Ok i think there is a way. When you write your record in the table, before
you
"M Fisher" <m.******@uku.co.uk> schrieb im Newsbeitrag
news:xs***************@newsfe5-win.ntli.net...
Is there a way to get the autonumber of a newly inserted record?
I am working with unbound forms, and using an append query to insert a
record into a table. I am then using a select query that returns the max
ID (the autonumber field) of the table. This gives me the correct number.
However, could this go wrong in a multi-user environment. I insert a
record, and say it gets ID 10, but before (even thoug it is a split
second) I read the max value, someone else inserts a record with ID 11.
What I need is a way to get the nubmer of the record I have just inserted.
Thanks