Run Time Error 3144

[mjancic]

Hi,

I have a problem with one script. This scrip is working in access 2003, but it wont work in access 2007. When I run it in 2007 I get run time error 3144, syntax error in update statement. Please take a look at this script below.

Private Sub cmd_update_Enter()

Dim ideal_px As Double
Dim strSQL As String

ideal_px = tbox_ideal_px.Value / 100
strSQL = "Update input_ideal_px set input_ideal_px.ideal_px = "
strSQL = strSQL & ideal_px & ";"

DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True


What should change in order to work in access 2007?

Thanks in advance,

Milan

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here