Help with Access FORM

I've created a form for a listing of approximately 250
names, addresses, etc. This form will be placed on other
computer desktops (as Access data pages) for staff to
utilize the data.

At the top of the form I would like to have a search, so
that staff will only have to type in the name of the
person they are searching for, in order to bring up that
form, an not have to cursor through the whole listing.
I've created a drop down box, that shows the whole list of
names, in alphabetical order, but cannot highlight a
specific name to bring the form up....thoughts,
suggestions, HELP?! Thank you.

Kim,

Your drop down box should be unbound and the row source should be PersonID,
LastName & ", " & Firstname. The bound column should be 1, column count 2 and
column width 0;2. Go to the Data tab of properties and set Autoexpand to Yes.
Name the comobox "MyCombobox".

Put the following code in the AfterUpdate event of the combobox:

Dim Rst As DAO.Recordset
Set Rst = Me.RecordsetClone
Rst.FindFirst "[PersonID] = " & Me!MyCombobox
Me.Bookmark = Rst.Bookmark
Rst.Close

When you begin typing in a last name, the dropdown list will automatically
scrool to the first last name beginning with the letters you typed in. When you
select a name in the dropdown list, the form will automatically jump to that
record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com



"Kim" wrote in message
...
I've created a form for a listing of approximately 250
names, addresses, etc. This form will be placed on other
computer desktops (as Access data pages) for staff to
utilize the data.

At the top of the form I would like to have a search, so
that staff will only have to type in the name of the
person they are searching for, in order to bring up that
form, an not have to cursor through the whole listing.
I've created a drop down box, that shows the whole list of
names, in alphabetical order, but cannot highlight a
specific name to bring the form up....thoughts,
suggestions, HELP?! Thank you.

Why not teach the users to use the "find" tool with the
surname field on the Form......it's the Binocular Icon or
you can get it in Edit/Find

Jim
-----Original Message-----
I've created a form for a listing of approximately 250
names, addresses, etc. This form will be placed on other
computer desktops (as Access data pages) for staff to
utilize the data.

At the top of the form I would like to have a search, so
that staff will only have to type in the name of the
person they are searching for, in order to bring up that
form, an not have to cursor through the whole listing.
I've created a drop down box, that shows the whole list
of
names, in alphabetical order, but cannot highlight a
specific name to bring the form up....thoughts,
suggestions, HELP?! Thank you.
.