I would encourage you to explore the uses of the combo box wizard. One
of the options allows you to set up a drop down list from which the
user makes a selection and that selection can move them to any desired
record in the database. So, for instance, if you had a database of
contact information, you could have one search combo for a LastName,
FirstName search of the primary person, and another for LastName,
FirstName of the spouse (sometimes those are different than the primary
person), and yet another that could search by company name, etc.
Here's how to explore this tool:
1] Go to the design view of the form you are using to view your data.
2] Be sure that your toolbox is showing.
3] Be sure that the "wand" tool is engaged (it should look like it's
4] Click on the combo box tool and then click on any blank area of the
form (remember that you can always move or resize the combo later)
5] At this point the wizard should kick into action. On the first
screen, the 3rd option is "find a record on my form based on the value
I selected in my combo box". This is the option you want. Click the
bullet for it.
6] Click "next".
7] The next screen lets you identify what field(s) the user will scroll
through to find the record they want. For example, if you wanted a
LastName, FirstName search, this is the screen that lets you identify
those two fields. Add the desired fields to the "selected fields" list
on the right side of the screen.
8] Click the "next" button.
9] The next screen shows you how the fields you selected will appear in
the drop down combo box.
10] Click the "next" button.
11] Give your combo box a meaningful label.
12] Click "Finish".
Now play with the tool you have created. You will discover that someReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10370
customizing will be necessary, but the basic tool will be in place.
For instance, I always sort the list and supress duplicates. Once you
have a combo box (or two!) in place, let us know and we can help withReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10370