Auto number

[qassim]

Hello,
I am using vb6 ado data control
i have table in acces2000 field
item_code Is it posible with
query to generate number
i mean already have in item_code
field 1000 and when
i pressed addnew then automaticlay
generate 1001 and display in text box
and acces table
Bye