Autonumber

R

rob peterson

I have a form with a text box that displays a number(which is an autonumber.
The number is an inventory box. You can look up an existing box by putting
in an existing number.

When I do an add number, "Auto Number" shows up in the text box instead of
the next new number, 1401. Any way to change this?

thanks
rob
 
R

Ray Cacciatore

When you define a field to be Autonumber, you are telling Access to generate
a unique, sequential number for you. However, you need to know that Access
only generates the number when the user "starts" typing data into a new
record. Not before that (by design). What's worse is that Access does not
reuse unused auto numbers. So if you cancel a new record, the autonumber that
was generated is lost and never to be used again.

If you want to use a number field the way you are describing, you need to do
it programmatically.

Ray
 
C

Craig

From what you wrote it seems that you might have to change the control source
of the textbox which is showing the autonumber.
 
Top