getting data

[manicminer]

Hello, I have this statement:
Set rst = CurrentDb.OpenRecordset("select * from ECR where [Serial] = " & frm_prehliadka_vyberkasa)

which ends with a runtime 3464 - data type mismatch in criteria expression. Serial is a text field in an ECR table and frm_prehliadka_kasa is a text field in current form.



I actually try to select the correct row from a table to be able to edit it. What am I doing wrong ? :-(

[pbaldy]

The syntax for text would be like:

Set rst = CurrentDb.OpenRecordset("select * from ECR where [Serial] = '" & frm_prehliadka_vyberkasa & "'")

[manicminer]

Wow, thanks a lot !!!! It works as intended. Now I'll have to find out why :-)
Thanks again ! :-)

[pbaldy]

No problem! Generally speaking text values need to be surrounded by quotes, so that will result in

Where serial = 'abc'

More here if you're interested:

http://www.baldyweb.com/BuildSQL.htm