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")

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