Autonumber

[qassim]

Hello,
I have table name
master and there is field
itemcod i want whenever I pressed
add buttton in form
it generate max number from table
and display in textbox
Is it possible with sql query
I am using Ado vb6 access 2000 table
Bye

[sanon]

sql = "select max(itemcod) as maxid from master"
rs.open sql,connection

text1.text = (rs!maxid) + 1

Did you get an idea?

[Edited by sanon on 09-02-2000 at 03:19 AM]