If you are using DAO, the code snippet won't (shouldn't) execute.
"EOF" means End of File, ie past the last record in the recordset. If no records are returned, then .BOF will be TRUE and .EOF will be TRUE.
In this line,
Code:
Set rs = dbConn.Execute(queryTorun)
"Execute" is for action queries ("Insert INTO", "Delete"), not "Select" statements.
I would use
Code:
Set rs = dbConn.OpenRecordset(queryTorun)
This line
Code:
dbConn.Execute ("Insert Into tableSalesInfo Values ('" & textbox1 & "', '" & textbox2 & "');")
tells me that there are only two field in the table because the field names are not in the statement.
Normally the statement would be
Code:
dbConn.Execute ("Insert Into tableSalesInfo( userid, Salesmanager) Values ('" & textbox1 & "', '" & textbox2 & "');")
Remember, I am talking about DAO. I don't use ADO.
My $0.02.....