Using a Combo Box to limit the entries of another combo box

[Cire via AccessMonster.com]

Let me illustrate with an example.

I've got 4 contacts, mr brown, mr smith, mr jackson and mr jordan. stored as
Fullname

mr brown and smith belongs to group "single" while mr jackson and jordan
belongs to "married", stored as Groups

so i want the 1st combo box-showing all groups to limit the what the user
sees in the 2nd combo box-Fullname. as in the real application there are many
more contacts and groups. as per example when the user selects
"single" in the 1st combo box, the 2nd combo box will only show mr brown and
smith for selection,
"married" in 1st box, 2nd will show mr jackson and jordan.
"Select all" in 1st box, 2nd will show all contacts.

hopefully you get the idea. So how do i go about doing this? and if the 1st
box can also have the multi-select capability, it would be great, i.e. if i
select married and single, it will show all names from these 2 grps -
assuming there are more than 2 grps in this case.

Thanks
Eric

 

[Guest]

hey Cire, check out this solution:
http://www.microsoft.com/office/com...42d5&mid=824ff5ee-887b-44c3-a4ca-efb3a5a342d5