Allen Thanks and your site is great.
Thanks again
Tony
"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:43f861c2$0$30715$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=blue]
> 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 programmatically
> If you want to do it programmatically, 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
> programmatically 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!" <blahblahblha@xyz.com> wrote in message
> news:YXOJf.1059$d%3.843@fe10.lga...[color=green]
>> 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)[/color]
>
>[/color]
