Pull down menu sort

[Ellen]

I have a church database of our cell groups that contains
addresses and phone numbers using Access 97. With a pull
down menu, I'd like to able to select reports of members
sorted on their cell group leader.

Thank you in advance.

Ellen

 

[Dirk Goldgar]

I have a church database of our cell groups that contains
addresses and phone numbers using Access 97. With a pull
down menu, I'd like to able to select reports of members
sorted on their cell group leader.

Thank you in advance.

I don't have enough information for detailed advice, but I can tell you
that you're going to need to base your combo box on a query -- either a
stored query or a SELECT statement in the combo box's RowSource
property -- that joins tables as needed to include the member name and
the cell group leader. Once you have such a query, you can have the
query sort on the cell group leader first, and then the member name (if
that's wanted).

 

[DanK]

This question highly suggests more of a database DESIGN
question than a simple control question. You probably
need one table with members' info, and another with "cell'
(whatever a cell is) info and link the two together. You
probably have other info that may have to be in other
tables as well. Then follow Dirk's recommendations.