From: Chuck Bartowski Chuck on
I am creating a login dialog. I want to have a combo or list box that lists
a pool of possible users. I would like to create a means to filter the list
of users in the box given three categories, such as City, State, and Country
for example. The filters would filter each other as well. For example,
under the State category, if I selected "New York," the user list or combo
box would only show those users in New York. The City category would also
only list those cities in New York and the country would automatically become
"United States." Any suggestions would be greatly appreciated
From: Douglas J. Steele on
See whether http://msdn.microsoft.com/en-us/library/bb404901.aspx helps. (It
doesn't matter whether you're not use Access 2007: it's the same in all
versions)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Chuck Bartowski" <Chuck Bartowski(a)discussions.microsoft.com> wrote in
message news:3AE71116-BDC6-4003-9529-1B5B557D2F20(a)microsoft.com...
>I am creating a login dialog. I want to have a combo or list box that
>lists
> a pool of possible users. I would like to create a means to filter the
> list
> of users in the box given three categories, such as City, State, and
> Country
> for example. The filters would filter each other as well. For example,
> under the State category, if I selected "New York," the user list or combo
> box would only show those users in New York. The City category would also
> only list those cities in New York and the country would automatically
> become
> "United States." Any suggestions would be greatly appreciated