Hi,
can anyone show me the way to generate ID with Integer and Character type?
like JobID: PA001,PA002,PA003....in database

Below is my code that only generate number:
With adoJob.Recordset
.MoveLast
JobID = adoVendor.Recordset.Fields(0) + 1
.AddNew
txtJobID.Text = vendorID
MsgBox "Your New Job ID is " & txtJobID.Text
End With

------------------------------------------------------------
Well, below is my problem that involve alphabet with number
(It will show "type mismatch" message):

With adoJob.Recordset
.MoveLast
JobID = adoJob.Recordset.Fields(0) + 1
.AddNew
txtJobID.Text = "PA00" & vendorID
MsgBox "Your New Vendor ID is " & txtJobID.Text
End With

-------------------------------------------------------------
i am using ADODC recordset,
can anyone help me
thankx


also anyone know how to set Expression?
like Numbering System: "CQ/03/002"
CQ mean company name
03 mean year 2003
002 mean Project number
so if user enter "CQ/00w/wd", it will say invalid expression

I think that you need Str() to make the number a string.

-PatP