Hi
Is there a possibility to find out which will be the next AutoNumber for such a field, before update?
I try to explain my intention:
There is a form just for inserting new records into a table with an AutoNumber field as ID. When the user opens the form, I want him to see which ID the new record will have.
Inserting the record in the first place (on load) and then finding out the ID produced by access is not a good idea, because the user could decide not to create a new record at all. And then, deleting the created record won't help, because the number has already be used, the next opening of the form will show a higher number, the one offered in the first place is gone forever,... And a Compact & Repair action of the whole DB, just for this litle issue...
Well, I think you, dear reader and adviser, have gotten an idea of my problem.
Thank you for your help
Walter