[RESOLVED] Yet another SQL issue

[MethadoneBoy]

Hi guys,

I'm having difficulty in getting text from a textbox on a form. What I'm trying to do is use a textbox for completing an SQL statement.

For example, say the textbox name is txtMonth. I have a String variable called insert

Dim insert as String
 
insert = txtMonth.txt
 
sqlStmt = "INSERT INTO <Tablename> VALUES ('" & insert "');"

There are no syntax errors or errors of any kind in the SQL statment, so it must be a problem getting the text from the textbox.

Any suggestions?

Thanks