Help with tihis (V.B. & Access)

[Erick de la Torre]

Someone can help me with this mistake:
the query runs perfectly, but when i run the next line it shows me an error "Type mismatch"

pQuery = "Select PubID, Name, Telephone from Publishers"
ReportWriter.F1Book1.ODBCQuery pQuery, 1, 1, False, True, True, True, False, pRetCode


Tnax

[kovan]

What is the next line after the query?

[Erick de la Torre]

This is the next line:
code:
_________________________________________________________
ReportWriter.F1Book1.ODBCQuery pQuery, 1, 1, False, True, True, True, False, pRetCode
_________________________________________________________

[Jop]

I think the problem is in this part

pQuery, 1, 1, False, True, True, True, False, pRetCode

What kinda variable is pQuery? and pRetCode?
and what kind of variables does it need?

for example if I code a Function like this

Private Function DoError(bool As Boolean)

'and you pass it a string:

Call DoError("yes")
'it'll result in a type mismatch.

So check if you pass it the right variables.