Filtering combo boxes in a form

[Scott Loupin]

I've got two databases with similar data in them (WestSide and EastSide).
I've set up two identical reports that is filtered by date and the client
name. I'm using one form to do the filtering.

Currently, I've used queries to combine the two client lists, so when I open
the combo box, I have many names I need to scroll through until I find the
one I want.

How can I use filtering to only see clients from one database or the other,
based on which report I open?

That is, if I open the Westside report, I'll only see the Westside clients.
When I open the Eastside, only Eastside clients will appear.

Currently, it's not so bad, but we're adding more sites, and more databases
to the list.

Any ideas?

Thanks