Type and Search Text Box

[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

 

[Rob Oldfield]

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)

 

[Anthony Bollinger]

Thanks, I'll try it now!

Tony

 

[Penguin]

Or try using a combo box instead.