Problem with Update Query

[illini]

I have an update query as follows:

RecID=LB_Search_Company.Column(0)

DoCmd.RunSQL "UPDATE Tbl_OCN SET Tbl_Company.Client = ""-1"" WHERE ((([Tbl_Company].[ClientID])= " & RecID & &quot);"

This gives me a Runtime Error '3464' ("Data type mismatch in criteria expression&quot.

However, the query runs fine if I replace the RecID with the actually number:

DoCmd.RunSQL "UPDATE Tbl_OCN SET Tbl_Company.Client = ""-1"" WHERE ((([Tbl_Company].[ClientID])= ""1233"&quot);"

Where is my original query going wrong? -illini

 

[beetee]

It looks like the 1223 is surrounded by quotes, while RecID isn't.

To make the two similar, you would use:
WHERE ((([Tbl_Company].[ClientID])= """ & RecID & ""&quot);"


Alternately, you can use single quotes to quote a string:
WHERE ((([Tbl_Company].[ClientID])= "' & RecID & '&quot);"

 

[illini]

Thank-you. The first worked great! -illini