Re: Cascading combo boxes

Tech-Archive recommends: Fix windows errors by optimizing your registry

You may like to try a set of 2 cascaded ComboBoxes. The first ComoboBox
simply has the 26 letters of the alphabets (assuming English) and the second
ComboBox only show the names starting with the selected letter in the first
ComboBox.

See The Access Web for cascaded ComboBox:

http://www.mvps.org/access/forms/frm0028.htm

--
HTH
Van T. Dinh
MVP (Access)


"BillD" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:148901c54ec0$810b0e80$a601280a@xxxxxxxxxx
> Thanks for the info- I will look at it.
> Actually, I like the combo being able to scroll through a
> lot of names.When I enter a name such as Depoe and press
> enter or the arrow for the dropdown, I get a list of say
> 20 names to start with and can scroll up or down to find
> the person I want. Works great. As I said, when I don't
> set the last,first and middle name to ascending, the
> search is fast and complete. The only problem is that it
> is not in alpha order. When I set the fields to ascending
> then I only can retreive a name in the first 60,000 names.
> The perfect set-up would be to have the list show up for
> any of the names in alpha order and to be able to at least
> look through all the names for that letter of the alpa.
> Thanks again- will respond after I look at your suggestion.
>
> >-----Original Message-----
> >Whoa! Even 60,000 names is far more than is reasonable to
> expect your users
> >to scroll through.
> >
> >Take a look at what Allen Browne has at
> >http://www.allenbrowne.com/ser-32.html
> >
> >--
> >Doug Steele, Microsoft Access MVP
> >http://I.Am/DougSteele
> >(no e-mails, please!)
> >
> >
> >
> >"BillD" <BillD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message
> >news:07843A82-1715-41A2-844E-9AB2427F6555@xxxxxxxxxxxxxxxx
> >>I have an access 2000 database with about 500.000 names
> and addresses. I
> >>have
> >> a form called "Enter/View constituents. When I open the
> form, information
> >> on
> >> the first constituent in the "ConstituentsTable" is
> displayed. I have a
> >> combo box at the top of the form
> called "NewNameSearch". When I select a
> >> name from the alphabetical list it populates the form
> with the new persons
> >> information.
> >> THE PROBLEM IS - The combo box is based on a query of
> LastName, FirstName
> >> and MiddleName from the Constituents Table. I have to
> sort the names in
> >> ascending order. The combo box will scroll down to
> approximately 60,000
> >> records and will not go any furthur. For example: If I
> type in Depoe and
> >> check the drop-down box, the list will only go to Depoe
> as Depoe is record
> >> 75,000. The last name I can scroll to is Clements which
> is record 60,000.
> >> If
> >> I do not set the sort to LastName ascending then I can
> scroll through all
> >> 500,000 records and select anyone I want. As the table
> records ID are not
> >> in
> >> perfect alpha order I have to have a sort by alpha to
> choose from. Can
> >> someone show me an answer to the problem. Perhaps I
> could have a Combo box
> >> first select a letter of the alpha and then have
> another combo to select
> >> from. HELP!
> >
> >
> >.
> >


.

Relevant Pages

  • Re: Cascading combo boxes
    ... >You may like to try a set of 2 cascaded ComboBoxes. ... >> lot of names.When I enter a name such as Depoe and press ... >> 20 names to start with and can scroll up or down to find ... >> any of the names in alpha order and to be able to at ...
    (microsoft.public.access.forms)
  • Re: Cascading combo boxes
    ... lot of names.When I enter a name such as Depoe and press ... 20 names to start with and can scroll up or down to find ... When I set the fields to ascending ... any of the names in alpha order and to be able to at least ...
    (microsoft.public.access.forms)