Hi -
I have two tables: Employers & Employees. They are joined by the EmployerID field in both tables.
I have two forms: One is a split form that shows the records in the Employer table and the other form shows the records in the Employee table.
On the split form I want the user to click on the employerID field and then the second form will be displayed with only the employee's that have the same EmployerID.
I've tried using an embedded macro:
OpenForm
Form Name: frm_ListofEmployees
View: Form
Filter Name:
Where Condition: =[EmployerID]
Data Mode:
Window Mode: Normal
and I tried a query using the criteria:
[Forms]![frm_ListofEmployees]![EmployerID]=[Employer]![EmployerID]
with no success. The macro displays all the employee records and query displays no records.
I would appreciate any and all suggestions.
Thanks - Rick