search text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanx
What should I do to make result display after each key stroke not just after
final enter.

alek_mil
 
Back
Top