Sort a Find Combo Box

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!
--
Thanks!

Dee
.

Relevant Pages

  • Re: Code to make form Read Only
    ... Will have to let you do your debugging, Dee. ... and Unlock and doesn't give me any errors. ... >>> Hi have a main form which contains a sub form, ... >>> entry person then inputs the responses to the questions. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Multiple Users @ same time 2003/2007
    ... Dee -- ... Regardless of whether you choose Project 2003 or 2007, ... Dale A. Howard ... "We write the books on Project Server" ...
    (microsoft.public.project)
  • Corrupt Documents
    ... Open and Repair the File ... Open the file with Test Recovery Converter" ... Dee ... Prev by Date: ...
    (microsoft.public.word.docmanagement)
  • Re: delegate question!
    ... Does it mean, anytime when a delegate is called, regardless of which ... worker thread they are in, it get executed in the primary UI thread? ... is it my stupid assumption? ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: OT When it gets tough for BushCo
    ... Regardless, care to provide some proof to your supposed fact? ... Prev by Date: ...
    (rec.boats)
Loading