Solved There is a syntax error for this SQL

[hucheunghugo]

        DoCmd.RunSQL "Update VIPcustomer SET VIPcustomer.Condition = 1 WHERE ((VIPcustomer.VIPID) = &X);"

I have tried different way, it stills shows syntax error.

 

[hucheunghugo]

X is a integer

 

[cheekybuddha]

        DoCmd.RunSQL "Update VIPcustomer SET Condition = 1 WHERE VIPID = " & X & ";"

 

[hucheunghugo]

Thanks a lot

 

[cheekybuddha]

I refer you back to this previous suggestion: similar problem

Use a variable so you can check the SQL from your concatenation:

  Dim strSQL As String
 
  strSQL = "Update VIPcustomer SET Condition = 1 WHERE VIPID = " & X & ";"
  Debug.Print strSQL
  DoCmd.RunSQL strSQL