Using a combo box selection to display multiple records in a sub-form

[KerryL]

I know this should be fairly easy, but I'm having some difficulty with it.

I'm using a combo box to select a field from the table. The selection in the combo box pulls up the entire record, which is displayed in a sub-form. So far, so good. However, if the combo box selection matches more than one record I'd like all of them to be displayed in the sub-form, not just the one selected (or the first instance of a match).

Example:
Table contains names/addresses of companies.
Combo box selection searches for "Cleveland" in the city column of the table.
All companies located in Cleveland should be displayed. (Currently only record matching "Cleveland" is displayed.)

Subform properties:
Can Shrink = YES
Can Grow = YES
The form has enough room to expand


What am I missing? Does the select statement need to specify 'ALL' or something similar?

Thanks in advance for your help,
Kerry

 

[braindead2]

my guess would be you have the subforms default view properties set up as single form. Change it to continuous or data sheet.

 

[KerryL]

Thanks BD2, but the subform is already set to continuous and it still only displays one record--the one chosen in the combo box.

Any other ideas will be appreciated.