Microsoft KB Archive/109324

{|
 * width="100%"|

ACC1x: Find Company Macro Does Not Work Correctly in NWIND.MDB

 * }

Q109324

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
The appropriate record for the company you selected in the Select Company To Find box on the Suppliers form in the sample database NWIND.MDB will not be displayed if you have chosen any of the alphabet buttons on the form.

For example, if you have chosen the "L" alphabet button, and then select a company that has a name that starts with the letter "E" in the Select Company To Find box, the record will not be displayed. Only companies whose names start with the letter "L" can be displayed.

CAUSE
The alphabet buttons on the Suppliers form apply filters to the records. If a filter is applied, only records that match the filter's criteria will be displayed.

RESOLUTION
Choose the All button, so that no filters are applied, before using the Select Company To Find box.

-or-

Add the ShowAllRecords macro action as the first line of the Find Company macro, which is the macro run by the Select Company To Find combo box. The ShowAllRecords macro action removes all filters. To add the ShowAllRecords action to the Find Company macro, follow these steps:


 * 1) Open the sample database NWIND.MDB.
 * 2) Open the Find Company macro in Design view.
 * 3) Select the top cell in the Action column, and select ShowAllRecords in the action list.
 * 4) Save the macro.

Steps to Reproduce Behavior

 * 1) Open the sample database NWIND.MDB.
 * 2) Open the Suppliers form in Form view.
 * 3) Select any company name in the Select Company To Find box.
 * 4) Choose the "L" alphabet button.
 * 5) Select a company in the Select Company To Find box whose name does not begin with the letter "L". Note that the record for the company is not displayed.

Keywords : kbusage

Issue type : kbprb

Technology :