hi,
I have a quick question.
I have a form where a user selects certain criteria and when they click the 'upload' button I would like it to first save the information selected from the criteria into a table (tblMain). My code for saving the information is below.
stSQL = "INSERT INTO tblMainLog(Project, Company, SystemType, System, Section) SELECT lblProject, txtContractor, cboSystemType, cboSystem, txtSection"
I can't get it to work though. What's the syntax to refer to a form control?
Any suggestions?
Thanks so much in advance.
I have a quick question.
I have a form where a user selects certain criteria and when they click the 'upload' button I would like it to first save the information selected from the criteria into a table (tblMain). My code for saving the information is below.
stSQL = "INSERT INTO tblMainLog(Project, Company, SystemType, System, Section) SELECT lblProject, txtContractor, cboSystemType, cboSystem, txtSection"
I can't get it to work though. What's the syntax to refer to a form control?
Any suggestions?
Thanks so much in advance.