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

 

[Linq Adams via AccessMonster.com]

I'm not really sure what you mean by a Go To combobox, but if you create a
combobox based on the same recordsource as your form, and then

Select "Find a record based on the value I selected in my combobox."

From the table or query the form is based on, click on the field you're
searching by (a field that is unique for each record) to move it to the right
side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the combobox.

Hit Finish.

Now you can drop the combobox down and scroll down to the item to search by,
or you can start to enter the item, and the combobox will "autofill" as you
type. Hit <Enter> and the record will be retrieved.

You'd have to have two comboboxes to do this with either the name or the SSN.

 

[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.