Sort a Find Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form based on two related tables. I have inserted a "find" combo
box from which users can select a family name.

I can't seem to get the list in the combo box to sort in alphabetical order,
even though the table that the names comes from is sorted and so is the
property of the form.

I then tried to base the form on a query and sorted that by family name, but
now when a particular family name is displayed at the top (main form), the
sub form shows ALL contacts, regardless of family; not just the ones for the
family displayed.

Thanks!
 
Tables don't sort data, only queries do that.

Can you give us more details about the query's structure that you're trying
to use? And the combo box's properties?
 
Hi Ken,

Thanks for your reply. I'm at the end of my rope with this.

My Family table and Meetings table are linked by FamilyID PK in Family to FK
FamilyID in Meetings.

In my query, I have both tables and have chosen:
FamilyName from Family
ContactLast, ContactFirst, RelationshipToStudent,TelNumber, etc. are all
from Meetings table.

When I create the form, I want it to show the Family Name at the top (main
form) and the contact information in datasheet style beneath it, so it will
show ONLY the contact rows for that family.

Thank you for any help you can provide.



--
Thanks!

Dee


Ken Snell said:
Tables don't sort data, only queries do that.

Can you give us more details about the query's structure that you're trying
to use? And the combo box's properties?
Click to expand...
 
Hi again,

I went back and started the query and forms from scratch and it miraculously
worked. No idea what I was doing.

I do have another question I posted in the last hour or so regarding bound
controls restricting their content to a specific family, if you have a moment.

Thank you so very much.
--
Thanks!

Dee


Ken Snell said:
Tables don't sort data, only queries do that.

Can you give us more details about the query's structure that you're trying
to use? And the combo box's properties?
Click to expand...
 
Back
Top