Like Fox, Access offers severals levels of search capability. Here's a
sample.
1. Find dialog
The simplest option in Access is to click in the field you wish to search,
and then click the Find button on the toolbar (binocular icon) or choose
Find on the Edit menu. This Find dialog gives you several options.
2. Filter By Form
If there might be several entries for the name you are searching for, you
might like to use the "Filter By Form" toobar button instead. This limits
the form to only the criteria you enter (on several fields if you wish), and
you can then use the navigation buttons to move through the results of the
search.
3. Finding records programmaticall y
If you want to do it programmaticall y, you could add an unbound text box to
the form (perhaps in the Form Header section), and use its AfterUpdate event
to find the record (if you expect only one) or filter the form (if you
expect multiple matches. For typical code, see:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html
Although the article uses a combo as an example, the code would be the same
for a text box.
4. Combining multiple search options
If you want an example of how to offer the user several specific boxes to
search different fields, in combination, and perform the search
programmaticall y based on the boxes where they actually entered something,
this database demonstrates the technique:
http://allenbrowne.com/unlinked/Search2000.zip
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Homey!" <bl**********@x yz.com> wrote in message
news:YX******** ********@fe10.l ga...
Hello all
I am new to Access.
I have imported data from an old FoxPro 2.x database.
This is probably the most basic function but I cant get a search box to
work. I need to search for company name and cant figure it out in access.
Tony (homey)
