I am using SQL to update a table using a form, code below:
strSQL = "INSERT INTO tblQuote ( ProductIDNumber, Range )
"SELECT tblProductData.ProductIDNumber, tblProductData.Range, " & _
"FROM tblProductData " & _
"WHERE tblProductData.FilterDescription" & strcboProdDesc & _
"AND tblProductData.Supplier" & strcbo1 & _
"AND tblProductData.CaseWeight" & strcbo2 & _
"ORDER BY tblProductData.FilterDescription;"
What I would like to do is attach data on the form and update the table with this data at the same time. IE The date and time which would be stored in a text box. Can anyone help!
strSQL = "INSERT INTO tblQuote ( ProductIDNumber, Range )
"SELECT tblProductData.ProductIDNumber, tblProductData.Range, " & _
"FROM tblProductData " & _
"WHERE tblProductData.FilterDescription" & strcboProdDesc & _
"AND tblProductData.Supplier" & strcbo1 & _
"AND tblProductData.CaseWeight" & strcbo2 & _
"ORDER BY tblProductData.FilterDescription;"
What I would like to do is attach data on the form and update the table with this data at the same time. IE The date and time which would be stored in a text box. Can anyone help!
