txt Box that shows all Employee with the same first name

  • Thread starter Thread starter gal
  • Start date Start date
G

gal

Hi guys,
I have a form with 4 text boxes. One of them is
txtName.Is there any way when a user types George all
employee who's name starts with George are being
displayed, I realize txtBox may be not the best choice.
How can I do that?

Thank you
Gal
 
Hi guys,
I have a form with 4 text boxes. One of them is
txtName.Is there any way when a user types George all
employee who's name starts with George are being
displayed, I realize txtBox may be not the best choice.
How can I do that?
Click to expand...

Use a Criterion in your Query of

LIKE [Forms]![YourFormNameHere]![txtName] & "*"
 
Thanks John,
This works perfectly. But can I have access finish a name
in the txtName.For example when user starts typing "Ge"
Access automatically finishes the name,let say George
Smith.
Thanks Galin
-----Original Message-----
Hi guys,
I have a form with 4 text boxes. One of them is
txtName.Is there any way when a user types George all
employee who's name starts with George are being
displayed, I realize txtBox may be not the best choice.
How can I do that?
Click to expand...

Use a Criterion in your Query of

LIKE [Forms]![YourFormNameHere]![txtName] & "*"



.
Click to expand...
 
Thanks John,
This works perfectly. But can I have access finish a name
in the txtName.For example when user starts typing "Ge"
Access automatically finishes the name,let say George
Smith.
Click to expand...

I'd suggest using a Combo Box based on the employee table (rather than
a textbox) - it has this autocomplete feature on by default.
 
Back
Top