change autonumber by code

I want to change the autonumber of the field in table to 1000
and to preserve the old number from 1 to 22.Is there any code in Visla basic to do
that?. This concerns my tables Houses where houseid up to now is 22.I want the next
autonumber to be 1000.
Can somebody help me ?

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!