Filter subform with field from main form

[mosh]

I have a main form with 4 subforms. They all work off specific fields from the mainform.

One of my subforms basically looks at holidays booked for the day the employee wants to book. The only problem is It picks up days book for employees across all departments.

The subform is based on a query, how can I make the subform filter based on the department as well?

I'v tried creating a text box and using a dlookup and then adjusting the query to lookup the department from the dlookup field but this crashes the db.

Regards
________
INOCENTBLONDE

 

[MStef]

Study "LINK CHILD FIELDS" and "LINK MASTER FIELDS" properties.