To create a search box on a form is very simple. While in design view of
your form, make sure you're viewing the Control Toolbox. Choose the button
indicated in the picture below:
I like to place the search box in the form header, so I draw it there. If you
have a full install
of Office, your Combo Box Wizard should kick in and help you at this point.
Choose the item indicating to "Find a record on my form based on the value I
selected in my combo box."
Hit Next, and choose the fields you want to SEE when you hit the combo box
Here, we show choosing Last Name, then First name. Access secretly grabs the
primary key field too, while you're not looking.
Hit Next and, if YOU chose your primary key field, Access will want to hide
it, and show only any other field(s) you selected.
Hit Next. Give the combo box a name like "SearchName" and hit Finish.
When we move to Form view, the results of our sample display as below. I have
narrowed the column width to hide actual email addresses for the purposes of
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.