Jan 25th, 2000, 08:15 PM
Hi,
I am using SQL command to Filter records in "Orders" table so that I can have list of Orders placed by individual employee . I also have "Employees" table with a Combobox populated with "employeenames". These two tables are linked by their "employeeID". I am having problem filtering the "Orders" table when I click on the combobox on the "Employees" table. When I click the combobox, I get an error "Type mis-march" on the SQL statement. Attached is part of the code. Any help would be appreciated. Thanks.
Albert
Private combo1_click()
SQLconnect = "Select OrderID,OrderDate from Employees, Orders Where Employees.[EmployeeID] = Orders.[EmployeeID]" _
And "Lastname='" & Combo1.Text & "'"
Load Form2
Form2.Show
End Sub
I am using SQL command to Filter records in "Orders" table so that I can have list of Orders placed by individual employee . I also have "Employees" table with a Combobox populated with "employeenames". These two tables are linked by their "employeeID". I am having problem filtering the "Orders" table when I click on the combobox on the "Employees" table. When I click the combobox, I get an error "Type mis-march" on the SQL statement. Attached is part of the code. Any help would be appreciated. Thanks.
Albert
Private combo1_click()
SQLconnect = "Select OrderID,OrderDate from Employees, Orders Where Employees.[EmployeeID] = Orders.[EmployeeID]" _
And "Lastname='" & Combo1.Text & "'"
Load Form2
Form2.Show
End Sub