Building a search box into a form

[JBloodgood]

I know very little about Access. I have a simple table of personnel. I want
to have a search box in my form to quickly get to a record. Everyone keeps
thinking they can type in the "Name" field and that it will go to their
name--instead it overwrites the first record. I want to put a box in the
header where they can type and have the form go to their record. All these
expressions, macros, codes, etc are foreign to me.

 

[Rick B]

The easiest way might be to include a combo box and let the combo box wizard
walk you through it. One of the options lets you find a record in the table
based on the value in the combo box.

 

[Rick B]

By the way, you say "Name" field. Hopefully you do not really have a field
called "Name". Typically you would store the LastName and FirstName as two
separate fields. This will allow you much more flexibility down the road to
display or print the name in any format you wish.