field value change

[javajom]

Hi,
What I'm trying to do is to change the value of the field within the record. The function will change the value of Username field within the secure table. By a sequence of input boxes I got a new username (newWord), which will replace the old one. I followed the book 'ACCESS VBA Programming for dummies' and still doesn't work. Any ideas???

Dim mySQL1 As String
mySQL1 = "insert into secure ( Username)"
mySQL1 = mySQL1 + "values (newWord)"
DoCmd.RunSQL mySQL1

 

[boblarson]

At first glance it would be that you are missing a space between the ) of Username and the word "values"

mySQL1 = "insert into secure ( Username)"
mySQL1 = mySQL1 + "values (newWord)"


Should be:

mySQL1 = "insert into secure ( Username) "
mySQL1 = mySQL1 + "values (newWord)"