Using TEXT fields in INSERT INTO's?

[tbpcpa]

I have stumped my toes enough on this one.... can someone else please look at this and tell me where the syntax error is....


db.Execute "INSERT INTO Roster ([League Code]) VALUES (" '" & txtLeagueCode.text & "'&quot"

If I change it to...

db.Execute "INSERT INTO Roster ([League Code]) VALUES ('1')" .... it works fine.....

Where am I missing it at?

 

[zemp]

I think that you have too many quotes. Try

db.Execute "INSERT INTO Roster ([League Code]) VALUES ('" & txtLeagueCode.text & "')"
Thanks and Good Luck!

zemp