Form with Subforms for filtering

[EllieFant]

I am making a database to help me keep track of our departments reading requirements. I am hoping to make a form that has several subforms that will be updated depending on what I click on in the subform before it.

This is what I have working at this point.

My unbound form is called frmUpdateEmployee. On this form I have an unbound listbox (called DeptList) which gets it's information from my luDept table (On Click event is set at me.refresh). I have created a subform called subfrmEmployeeName who's control source is a query. In this query I have the Dept field criteria set [forms]![frmUpdateEmployee].DeptList. My first subform works great!

What I want to be able to do is to have another subform that I can update the employee's information based off what I have chosen in the subfrmEmployeeName. (Query would be based off the field EmpNum which is unique to each employee).

I am not sure how to write the criteria so that the query knows to look in the EmpNum field on the subform contained on the frmUpdateEmployee.

Does someone have a simple example of making this work that I can follow or know of somewhere to find help?

I would appreciate any help you can offer to help me make this work.

Ellie

 

[Scribe]

try: Forms![frmUpdateEmployee]![subfrmEmployeeName].Form![EmpNum] as criteria. I think that will work.

Later.

[This message has been edited by Scribe (edited 06-09-2002).]