split-form with dropdown filter

[dr.tom]

I am looking for some help with my split-form. When the supervisor opens the split-form they are able to see every record for every person in every department. How can I add a dropdown box that will filter the viewed records by the dept requested in the dropdown box. I would like this option to be on the actual form itself. Thanks for the help.

 

[SmallTime]

Assuming by split form you mean a main form and a subform

- Create a query with all the data that you need on the subform
- in the 'department' field of that query, under Criteria, build a reference to the drop down box on the main form (which you would have already created and I assume already shows the department name).

The Criteria will look something like;
[Forms]![YourFormName]![YourDropDownBoxName]

- Base your subform on the newly created Query

- You might need to requery (sort of refresh) the subform after making a selection in your drop down box.

the syntax for this could look something like Me.YourSubfomName.requery

Hope it helps

SmallTime

 

[SmallTime]

Second time today I've forgotten to mention alternatives.

You could also apply a filter which might be easier

Take a look at

DoCmd.ApplyFilter Method

SmallTime