Error Recovery

[huzaink]

Hi i m huzain

i m using vb and ms-access and strFilter command also.i got a error
for an data type mismatch
error the code below is there
Case "BE_Invoice"

strSQL = "Select BEDocNo,Inv_Sr_No,Inv_No from b_Invoice"
strFilter = "BEDocNo=" & frmBEJob.txtJobno
this code contain the table name is an b_invoices it should having an
fields like
BDcoc,Inv_Sr_No,Inv_no
this above fields daty type is an "Text"

i got a error for an "3464 Data type mismatch error"
whenever the i to press the Debug it should go for an
module under below

Set GetRec = IECDB.OpenRecordset(strSQL)
the error will goes to this code
please clear me

[Allen Browne]

If this line gives the error:
Set GetRec = IECDB.OpenRecordset(strSQL)
how did you declare GetRec?

If you used:
Dim GetRec As Recordset
try:
Dim GetRec As DAO.Recordset
Explanation:
http://allenbrowne.com/ser-38.html

If you open table b_Invoice in design view, what data type is the BEDocNo
field? If text you need extra quotes:
strFilter = "BEDocNo = """ & frmBEJob.txtJobno & """"
Explanation:
http://allenbrowne.com/casu-17.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<hu*****@gmail.comwrote in message
news:11**********************@h3g2000cwc.googlegro ups.com...

Hi i m huzain

i m using vb and ms-access and strFilter command also.i got a error
for an data type mismatch
error the code below is there

Case "BE_Invoice"

strSQL = "Select BEDocNo,Inv_Sr_No,Inv_No from b_Invoice"
strFilter = "BEDocNo=" & frmBEJob.txtJobno

this code contain the table name is an b_invoices it should having an
fields like
BDcoc,Inv_Sr_No,Inv_no
this above fields daty type is an "Text"

i got a error for an "3464 Data type mismatch error"
whenever the i to press the Debug it should go for an
module under below

Set GetRec = IECDB.OpenRecordset(strSQL)

the error will goes to this code

please clear me