Distinct Combo Box Value only displaying one record in form

[CementCarver]

I've designed my search combo boxes to only display distinct values of a particular field. But when I select one of these values, which should yield many records in my form, I only get one record displayed, related to the combo box.



Rather, I was hoping to be able to display a subset of records.

Is there any way of displaying the complete set of records in my related form, rather than just one record?

For example, my combo box allows the user to select either district 1 or 2 as a search criteria. But I only get one record if I select 1 as my search.

Can anyone help?


CementCarver

[orange]

Show us some code so we can see what you have.

[CementCarver]

I have no code to drive this functionality. I'm only using what's given to me in the access 2010 forms environment.

[orange]

Can you post your database, and provide some details on what and where I should be looking?

[CementCarver]

Unfortunately, due to a confidentially agreement, I cannot share any of this data. All I can say is that I have one column called district. All of my members belong to either district one or district two. When I built my membership form, I used a combo box to search for particular records. The company name combo box that i have working, works well, since it's able to drill to a particular membership record. But the district combo box, after I made it select only distinct records, ie. 1. or 2, after I select district 1, only the first record complying with this search comes up, but they are not grouped or filtered.

CementCarver

[Missinglinq]

I have no code to drive this functionality. I'm only using what's given to me in the access 2010 forms environment.

If you're saying that you're using the Third Option from the Combobox Wizard, to do this, all you're going to get is the first match, as it uses the FindFirst method, which does just that, finds the first match.

To do what you're talking about you'll need custom code in the AfterUpdate event of your Combobox. Search here and/or elsewhere using the terms 'MS Access' and 'search form.'

Linq ;0)>

[CementCarver]

thx Missinglinq.