hmm...I tried this:
Code:
"INSERT INTO Members VALUES(" & NewID & ", " & Text1(0).Text & ", " & Text1(1).Text & ", " & Text1(2).Text & ", " & Text1(6).Text & ", " & SSN & ", " & Text1(7).Text & ", " & Text1(5).Text & ", " & Typevar & ", " & FFID & ")"
and I got this error:
"The name 'hj' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted."
"hj" is what I typed into the first of the textboxes as a test.
Any help is appreciated. thanks.