Help with Access FORM

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

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.
 
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
 
Back
Top