Re: Cascading combo boxes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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)
  • Re: Command Window
    ... "Alpha" wrote in message ... scroll to the first screen. ... and adjust the screeb buffer size to be much bigger than that the Window size. ... I think it will give you scroll bars then. ...
    (microsoft.public.windows.vista.general)
  • Re: ITRC patch site
    ... In article, "Ian ... 7.3-2 ALPHA. ... on a VT320 now not a DECterm so I can't scroll back up and see what I ...
    (comp.os.vms)