Type-in Form to find individual record

  • Thread starter Thread starter Scott B
  • Start date Start date
S

Scott B

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
 
Scott said:
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
Click to expand...

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.
 
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
 
Back
Top