List box populated depending on combo box selection

[webgirly]

I have quite a simple problem I think, but i don't know if I'm able to explain it properly.

I have three tables:

one for contacts
one for the groups contacts are a member of
and a junction table to solve the many to many relationship there.

What I want, is to create a form, with a combo box with a drop down list of groups. When a user selects a group, I'd like all the contacts (including *some* of their fields) to populate the list box below.

So a user can easily view the members of each group.

Does that make sense?

 

[wazz]

this is similar but involves opening another form. take the query from the second form in this example and make it the row source of your list box. in your combobox create an After Update event to requery the list box.

http://www.access-programmers.co.uk/forums/showthread.php?t=101122

 

[webgirly]

Thanks for that! I think I can grasp the method in principle, but in practice, it's not working for me.

The list box either shows nothing, or just one entry, which is the same every time....

sorry...

 

[Ethereal]

Make the query for the listbox rowsource group table and the criteria be the combo box. Then on the after update event fo the combo box, call listboxName.requery

 

[webgirly]

Thanks for that! it's all working beautifully!

 

[Ethereal]

not a problem

 

[mjseim]

How do you make the criteria be the combo box?
In my form, the item is named "Category"
In my Governing table, the item is [Category]
In my dependent table, the item is [ItemCategory]