Help getting sql syntax correct

[beatleman]

Hello, just need some help correcting the syntax with the below. Vend is the name of my input textbox on my form, but the value entered will not copy into my table 'Notsent' Can anyone spot why? Thanks.

db.Execute " INSERT INTO Notsent " _
& "(Vendors) VALUES " _
& "('&Vend');"
dbs.Close

 

[RuralGuy]

db.Execute " INSERT INTO Notsent " _
& "(Vendors) VALUES " _
& "('" & Me.Vend & "');"

 

[beatleman]

re:

Thankyou. Worked great

 

[RuralGuy]

Glad I could help.