Autonumber

  • Thread starter Thread starter rob peterson
  • Start date Start date
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
 
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
 
From what you wrote it seems that you might have to change the control source
of the textbox which is showing the autonumber.
 
Back
Top