Dear Tek Tips
I am getting error 3073 (operations must use an updateable query) when I run this code to insert into a table from another table.
Criteria is a selection from a multilist select. It contains customer id numbers.
Could this be a problem that I am addressing these numbers as text instead of numbers?
Appreciate your help
Regards
John
I am getting error 3073 (operations must use an updateable query) when I run this code to insert into a table from another table.
Code:
strsql = "Insert into tblchngecustomers Select * From customers WHERE customersID In (" & Criteria & ")"
db.Execute strsql
Criteria is a selection from a multilist select. It contains customer id numbers.
Code:
Set ctl = Me![CustomerList]
For Each Itm In ctl.ItemsSelected
If Len(Criteria) = 0 Then
Criteria = ctl.ItemData(Itm)
Else
Criteria = Criteria & "," & ctl.ItemData(Itm)
End If
Next Itm
Could this be a problem that I am addressing these numbers as text instead of numbers?
Appreciate your help
Regards
John