[RESOLVED] error 3265

[kirara22]

how to generate automatic IDnumber of customer?


i try the following code:

Const DBPATH = "dataBASE.mdb"
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPATH

SQL = "SELECT MAX(IDNUMBER) FROM table1"

newID_Number.caption = rs.Fields("LAST_ID_nuMBER") + 1

End Sub

i've got he following error mesage.
item cannot be found in the collection corresponding to the requested name or ordinal.

sorry im really new vb

tnx