I keep getting 2501 error

[Coldsteel]

Hello all,

I am trying to build a simple search form which will allow a user to enter a product id, perform the search and then and open another form with product details but every time i try to run it i get the 2501 error and it does not open the form. The Product ID is 9-15 digits long. Here is my code any help would be appreciated.


Dim strWhere as String

strWhere = "[MyProduct] = " & ME.SearchProd

DoCmd.OpenForm "frmMyEditForm", acNormal, , strWhere

 

[pbaldy]

See here for the syntax required if the product ID is text:

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

 

[Coldsteel]

Works like a charm. thanks for the link and the help

 

[pbaldy]

No problem, glad it helped.