Need help with Syntax

[mattc66 via AccessMonster.com]

Would this be the proper syntax if PO_NO is a text feild?

Set rs1 = db.OpenRecordset("select * from tblPODetail where PO_NO = " + CStr
(PO_NO))

Thanks
Matt

 

[Klatuu]

Almost
Set rs1 = db.OpenRecordset("select * from tblPODetail where PO_NO = '" + CStr
(PO_NO) & "';")

 

[mattc66 via AccessMonster.com]

Thank you

Almost
Set rs1 = db.OpenRecordset("select * from tblPODetail where PO_NO = '" + CStr
(PO_NO) & "';")

Would this be the proper syntax if PO_NO is a text feild?

[quoted text clipped - 3 lines]

Thanks
Matt