I am passing a variable from one on

[CookieNZ]

I am passing a variable from one one to the another e.g.

Public Sub mysub(ByVal number As Integer)

cmdsupport = dbconn.CreateCommand
cmdsupport.CommandText = "select * from supportcall where ID = '" & number & "'"
dbsupport.Fill(dssupport, "SupportCall&quot

However when the program fills the dataset, it crashes warning me that "Additional information: Argument 'Prompt' cannot be converted to type 'String'"

Do I need to convert the number variable somewhere?

It is an Access db connection

 

[krisbrixon]

Have you tried:

Public Sub mysub(ByVal number As Integer)

cmdsupport = dbconn.CreateCommand
cmdsupport.CommandText = "select * from supportcall where ID = '" & CStr(number) & "'"
dbsupport.Fill(dssupport, "SupportCall&quot


Kris