Where clause in SQL statement problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Giganews (hereinde_at_yahoo.com)
Date: 02/09/05 

Date: Wed, 9 Feb 2005 00:04:09 -0500

I have an Access 97 database were I am opening a recordset in a module
referencing a control on a form. For some reason when the code executes I am
getting an error message stating missing operator and I am not sure why. The
code is as follows:

Public Sub Module1()
Dim rst as recordset

Set rst = CurrentDb.OpenRecordset("SELECT * From tblStores WHERE
tblStores.[STORENAME] = " & [Forms]![frmStoreForm]![STORENAME] & " ")

[STORENAME] is a text field which is why I delimited it with "

Am I missing something?

Any help would be appreciated.

Regards,
Mark

Quantcast