Showing Autonumber value

[Rudi Groenewald]

Hi all,

When entering data into a single record form with an autonumber, you can't
see the autonumber's number, it only displays "(AutoNumber)"

I would like the number the server assigns to that record to be shown as
soon as the user starts typing on the form. How can I achieve this?


Thanks alot in advance
Rudi G

 

[Angi]

Rudi,
The number should show up as soon as the user starts typing in a field.
It reserves a number (Autonumber) until the record is dirtied (typed
in). This is not happening?

Angi
(knows enough to get into trouble)

 

[Roger Carlson]

Generally speaking, if the number is important for the user to see, you
shouldn't use an Autonumber field. You should create your own
auto-incrementing field. This will allow you to see the number as you enter
the new record.

On my website(www.rogersaccesslibrary.com) is a small sample database called
"AutonumberProblem.mdb" which illustrates how to do this with the DMax
function. As you will see, the number appears as soon as the New Record
appears.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L