I've emailed customer support but was hoping someone could lend a hand before I pull my hair out. This tutorial was extremely helpful but I just can't accomplish what I'm aiming for.

I have multiple tables to include a junction table; employees, their training dates, & their due dates. I want to create a form for the end user that uses a combo box to select an individual & searches & displays all his/her info in datasheet view. Creating a command button to get ALL of the employees' info was easy enough but this is proving to be a pain. Thanks for any help

---

Reply from Alex Hedley:

Just an FYI Customer Support isn't for Technical Questions, this is what the Forum and TechHelp are for.

You will want to create a Query with a CRITERIA. This is where you can say SELECT * FROM InfoT WHERE EmployeeID = x
Your x is the value from your ComboBox.

See this Tip for Parameter Query.

See this Tip for using a value from a Form.