Look up employee name in Form

[Learning Access]

Hi - Wondered if someone can help me.... I have a main form named MASTER FORM
that includes various tabs within it to look up employee information. I need
to be able to create a field to look up by social security number or name - I
have created a GO TO combo box but I am thinking this is not the route I want
to go due to the fact that there are almost 1000 employees that I would need
to scroll through. I want a box that I can type in either the soc sec or the
employee name that will allow me to go right to that employee's MASTER form.
How do I accomplish this? Is this a query? Any help is appreciated!
Thank you
Beth

 

[Yecenia]

Hello Beth,
I found myself in the same situation. I used a query and put brackets
under the criteria I was searching. This doesn't help for misspellings, but
hopefully you know exactly want you need to search form.

There are other helpful tools such as ctrl+F and the autofilter. If you
have Access 2007 all forms come with a default search tool on the bottom
navigation bar.

I hope this helps.

-Yecenia

 

[KARL DEWEY]

A combo box has a property called Auto Expand and if you set it to Yes it
automatically scrolls as you type in the data.

 

[John W. Vinson]

On Tue, 28 Apr 2009 12:21:01 -0700, Learning Access <Beth

I have created a GO TO combo box but I am thinking this is not the route I want
to go due to the fact that there are almost 1000 employees that I would need
to scroll through.

It's not necessary to scroll through a combo box. If its default Auto Expand
property is set, the combo will jump right to the names starting with R if you
tab into it and type R. Typing Rodri will probably jump right to the single
record for Rodriguez. This works only on the first nonzero width text field in
the combo, but it's very handy.