Solved Runtime Error with CurrentDB.Execute Update

[Momma]

I get this error when I run the code below and can't figure out what the problem is.
Any help would be much appreciated!
Thanks

    If ContactInv > 0 And Payment > 0 And DogInv = 0 Then
           CurrentDb.Execute "UPDATE tblInvoices SET DogID = CurrentDogID" _
                & " WHERE InvoiceID = " & CurrentInvoiceID & ";"
    End If

 

[arnelgp]

maybe:

    If ContactInv > 0 And Payment > 0 And DogInv = 0 Then
           CurrentDb.Execute "UPDATE tblInvoices SET DogID = " & CurrentDogID  _
                & " WHERE InvoiceID = " & CurrentInvoiceID & ";"
    End If

 

[Momma]

maybe:

    If ContactInv > 0 And Payment > 0 And DogInv = 0 Then
           CurrentDb.Execute "UPDATE tblInvoices SET DogID = " & CurrentDogID  _
                & " WHERE InvoiceID = " & CurrentInvoiceID & ";"
    End If

It is exactly that, Arnelgp. Thank you for your help!