Type and Search Text Box

  • Thread starter Thread starter Anthony Bollinger
  • Start date Start date
A

Anthony Bollinger

I have a form set up in tabular or table-like layout. Basically, it is a
list or scrolling view of the data. The data contains last names, and I
want to put an unbound text box at the top of the form and allow users to
type into that box and have Access search the initial part of the name that
matches what the user types.

I think I recall seeing an example or two of this online. Does anyone have
a suggestion?

Many thanks,
Tony
 
You need to catch the on change event of the text box. In there, you can
grab the current text by using me.ctlName.text. With that... build an SQL
string that you can use as the row source of the list box (or the relevant
property of whatever control you're using to display the list)
 
Back
Top