There's a difference between the phrases
"SELECT * FROM Employees WHERE EmployeeID = [cbxEmployee]"
and
"SELECT * FROM Employees WHERE EmployeeID = [cbxEmployee].column(1)"
sql interpreter (btw who is that?) can not interpret the second. In order to make it work, you have to rewrite it as
"SELECT * FROM Employees WHERE EmployeeID = " & [cbxEmployee].column(1)
I wonder as to why the combobox object name can be passed as SQL but not its column property.
"SELECT * FROM Employees WHERE EmployeeID = [cbxEmployee]"
and
"SELECT * FROM Employees WHERE EmployeeID = [cbxEmployee].column(1)"
sql interpreter (btw who is that?) can not interpret the second. In order to make it work, you have to rewrite it as
"SELECT * FROM Employees WHERE EmployeeID = " & [cbxEmployee].column(1)
I wonder as to why the combobox object name can be passed as SQL but not its column property.