update query question

Ok this solved the problem, but now im getting "label not defined"
Code:
CurrentDb.Execute "UPDATE body SET body.[VIN] = """ & Me.updatevin & """," & _
" body.[CMR] = """ & Me.updatecmr & """," & _
" body.[TR rekina datums] = #" & Me.updatedatums & "#;"

p.s. Before like half a year I was realy close to dutch, but nej, I am latvian :)
 
But "datum" is dutch... :P Or is it Latvian as well??

I have no clue what this error means, sorry :(
Double check your column names and the names of the textboxes on your form, just to make sure.
 
Probably this is for another topic, different sort of thing. It says:

This error has the following cause and solution:
A line label or line number is referred to (for example in a GoTo statement), but doesn't occur within the scope of the reference.
The label must be within the procedure that contains the reference. Line labels are visible only in their own procedures.


There should be something wrong with goto in case of error. I tried to google something aswell, but there are loads of opinions, can't understand why it works in other subs in the same way:S

Ye it is the same, we have loads of similarities with german words, so some things are not realy far from dutch.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom