By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,451 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,451 IT Pros & Developers. It's quick & easy.

Filtering combo boxes in a form

P: n/a
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?

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.