Solved: Update Query

[Skaapn]

Hi,

I'm trying to update a record in my database.
This is the query:

[vba]
Dim UpdateQuery As String
Dim currentOfferteNummer As Long
currentOfferteNummer = (Form_Main.Hidden2)

UpdateQuery = "UPDATE [Offerte Items] SET [Item 1] = 'test' WHERE [Offertenummer] = '" & currentOfferteNummer & "'"[/vba]
When i run this query, i get the following error message:
"Data Type Mismatch in criteria expression"


I'v checked both datatypes.
Offertenummer is defined as a Number(long int), same as the variable 'currentOfferteNummer'

I don't know why i get this error message

[Skaapn]

I've solved it by using the Query designer and switch to sql view to get a working code