Petie said:
I am designing a data base and forms for Purchase Orders.
I would like the Auto Number to display the actual number
in the form. It doesn't do this until after I go by and
then come back to the form. Any suggestions would be
appreciated.
This sounds as if you may be going down the wrong path!
Autonumber is designed only to provide a unique identifier for records
in a table. This is used internally by Access in building relationships
between tables according to your design. The actual values that
Autonumber delivers are unimportant and should never be exposed to
users or have any external meaning at all. Depending on the design and
use of the database, Autonumber will develop gaps, become
random and go negative.
For any number series that you want to control or have available
externally, you must design your own. There are several schemes
available depending on what you want to do. If you say what you are
trying to achieve, we may be able to help you.
hth
Hugh
