get the next value of an autoincremental field

[frank]

Hello everybody:
I would like to get the next value of an autoincremental field. I don't want
to know it by going to the last record ang getting the last value used. I
suppose access uses an internal table to mantain this sequence. Is possible
to access it?
How?

Thank you very much.
Frank

 

[ruralguy via AccessMonster.com]

If you are talking about an AutoNumber field, I would not recommend what you
are proposing. Because of the way AutoNumber fields work, there is no
guarantee the next number will actuall be used. It could easily be skipped.

 

[Stefan Hoffmann]

hi Frank,

I would like to get the next value of an autoincremental field. I don't want
to know it by going to the last record ang getting the last value used. I
suppose access uses an internal table to mantain this sequence. Is possible
to access it?

Why do you need to know this value before actually creating it with a
new data row?


mfG
--> stefan <--