Please forgive me for not stating my question well. It may have been a little frustration with not getting everything to work as it should My question was that I wanted to create an "Insert into" statement to copy information from a text field on one form titled "controlnumber" to a field "controlnumber" in a table titled "SurveyQuestion"
I was able to figure it out. As advised, I did change the reserved word "number." I changed the statement to the following and it did work for me.
STRSELECT = "insert into SurveyQuestion (controlnumber) VALUES(controlnumber)"