Switchboard drop down box that takes you to existing forms

[DTP]

Table name is tblWIP1
Form name is frmWIP1

I am using Access to track loan customers. I currently have a field in the
table/form that is Borrower Name.

At my last job, we had a drop down box on the switchboard which listed all
of the Borrower Names that were already entered into the database. Once we
selected the name from the drop down box, we were able to hit a button and it
would take us to the form with all the information. It would also group all
the forms together for that specific Borrower Name. So if there were
mulitple records for one customer, we would be able to hit the arrow button
and it would take us to their next form/record.

I just started a new job and would like to set up this same feature on our
Access Database. Can anyone walk me through the steps of how to accomplish
this?

Thank you so much for your help in advance!!

 

[Arvin Meyer [MVP]]

There is a wizard to build the dropdown for you. Just select the 3rd option
when creating a combo box using the form design wizards. Ad the Primary Key
(ID field) and the Borrower Name field to the form.