filter by part of name

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

Guest

I have a query that returns the result of a last name that is typed into an
unbound text box.
instead of typing the entire last name, ie "Smith" i want to type S, then m,
then i
and the query will return the results with each key click. so after i type S
all patients that last name begins with s will appear, then it will furhter
be filtered when i type "i". what do i put in the criteria of the query?

thank you
russ
 
In your query set the lastName sort to ascending. On your form use a
combobox rather than a textbox. Select the combobox in design view, open
properties, go to the Data tab and set auto expand to Yes. The combobox will
now do what you are asking to do.
 
Back
Top