Re: Type-in Form to find individual record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Scott B wrote:
> Good morning,
>
> I would like to know if it is possible to create a form that has a
> text box into which I can start typing a last name and have Access
> 2000 start displaying the possible results within the bound table of
> the control. I would like to be able to click a command button and
> go to the record on a form of the name found in the typing process.
>
> I hope this is clear.
>
> Thanks you,
> Scott B

While this is possible it would be a pretty resource intensive UI to use,
particularly over a network. Have you looked at the AutoExpand feature of a
ComboBox? It does exaclty what you want. As you start typing the list in the
ComboBox jumps to the first entry matching what you have typed so far. In
addition one of the choices in the ComboBox wizard is one that takes you to the
record matching the ComboBox selection. If you used that you would be done in
about 30 seconds.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.



Relevant Pages

  • Re: Type-in Form to find individual record
    ... > Scott B wrote: ... >> go to the record on a form of the name found in the typing process. ... > in the ComboBox jumps to the first entry matching what you have typed so ...
    (microsoft.public.access.formscoding)
  • Re: I am starting to prefer comboboxes than textboxes
    ... weirdness when I start typing in the Sample Buddy field. ... I've got the demo app running right now. ... why I prefer a combobox in so many other apps. ...
    (microsoft.public.vb.general.discussion)
  • Re: Disallow editting of certain words
    ... out and replaced the selected text (either typing or ComboBox) that ... the selected text was 1 character long no matter what I did. ...
    (microsoft.public.vb.general.discussion)
  • Re: I am starting to prefer comboboxes than textboxes
    ... Actually, I said that, but I did want to disabuse of you of a few false preconceptions. ... If you have a fixed list of itmes then use a combobox. ... Ever watched someone "go to" a website by typing its name into the google search bar, then clicking on the first link to come up? ... a numberbox (textbox with an updown control). ...
    (microsoft.public.vb.general.discussion)
  • Re: I am starting to prefer comboboxes than textboxes
    ... consecutive numbers the combobox autocomplete is pointless. ... weirdness when I start typing in the Sample Buddy field. ... Typing the first digit '2' is an invalid entry since the minimum accepable ...
    (microsoft.public.vb.general.discussion)