Find records based on a field in a form

[rbw95662]

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

[pbaldy]

Here's the VBA method:

BaldyWeb wherecondition

I don't use macros, but that syntax seems off; you need to specify the field to filter on and where to find the value. If you want to stay with the macro, check in help for the required syntax.

[rbw95662]

Paul - Your example worked perfectly. Thank you - Rick

[pbaldy]

No problem Rick; glad it helped.