search text box

A

alekm

Hi,
whats the best strategy to make search text box. I want, while typing in a
search text box, a list to display only results that have substring that is
equal to string in a search text box.

thanx

alek_mil
 
M

Matt

Set the Listbox’s Row Source property to a parameter query.

SELECT Table1.* FROM Table1
WHERE (((Table1.YearField) Like "*Forms![YourForm]![SearchTextBox] *"));

On the AfterUpdate Event of the Form’s Text Box code:
Me.YourListBox.Requery
 
A

alekm

Thanx
What should I do to make result display after each key stroke not just after
final enter.

alek_mil
 
Top