I have two forms(1 and 2). Form 1 have a populated DataGrid with a combobox filled with "Employeenames" from the "Employee" recordset. The form 2 has a populated DataGrid filled with "Orders" records. I would like to filter the "Orders" records to give me a list of "Orders" placed by any employee whenever I click on the combobox to pick a name. Note I am using ADO and the link between the recordsets are the "employeeID".

I really need help on this one. Counting on your co-operation. Thanks.