Counter Not Starting From Zero? 1

[TZyk2003]

Hey everyone - great to be here!

I'm trying to do something that seems relatively easy. I have a bound form that is tied to a record set. I have a primary key of Order ID and I'd like each time you click the "new record" button a new Order ID is automatically populated with the current order + 1.

I tried the whole primary key Autonumber deal but the counter starts at 1 and not 100,000, which is what I'd like.

Any ideas? Dmax perhaps?

THANKS!

-Tim

 

[Crowley16]

you can set the number that an autonumber starts at in the table level...

one of the properties in the design view of the table and autonumber column.

--------------------
Procrastinate Now!

 

[TZyk2003]

Thanks for the reply!

I don't see that option in Access 97 - maybe that's my problem. For an autonumber, there are two Field Properties tabs - General and Lookup. General has 5 rows, 1.) Field Size, 2.) New Values, 3.) Format, 4.) Caption, and 5.) Indexed.

The lookup tab is blank.

So I don't see where you enter the starting autonumber.

Any ideas??

THANKS!

-Tim

 

[TheAceMan1]

How are ya TZyk2003 . . .

Have a look here: How to Use an Append Query to Set Initial Value of an AutoNumber Field

See Ya! . . . . . .

 

[TZyk2003]

That worked. THANKS!