Re: Type-in Form to find individual record
- From: "Scott B" <scottb@xxxxxxxxxxx>
- Date: Sat, 25 Jun 2005 13:11:02 -0400
It's funny how the simplest things cause us to look for the most complex
answers. That is so simple and exactly what I wanted. I attached several
commnad buttoms to it to go to other forms for that record and voila. Like
butter.
Many thanks,
Scott B
"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:rycve.2692$Lj2.1741@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>
.
- References:
- Type-in Form to find individual record
- From: Scott B
- Re: Type-in Form to find individual record
- From: Rick Brandt
- Type-in Form to find individual record
- Prev by Date: cboBox NotInList Problem
- Next by Date: Recordset question involving sql and a subform
- Previous by thread: Re: Type-in Form to find individual record
- Next by thread: POP UP FORMS focus - URGENT HELP NEEDED ??
- Index(es):
Relevant Pages
|
