Combo box lists everything

rhino213

Registered User.
Local time
Today, 13:20
Joined
Jul 19, 2005
Messages
15
Ok! So I've binned the pivot table and gone for a continuos form option that allows the double click event that I'm after. A new problem has appeared.

On my main form I have 3 combo boxes (programme, product & company). When I click on any of the combo boxes i get a list of everything in the column it relates to. That works fine but it looks very cluttered. I'd like to have everything listed once only so that when i click on a programme it will filter the subform to show only companies working that programme.

Hopefully this little thingy I've put below will explain it a bit clearer

At the moment the programme combo box is displaying....

AAA
AAA
CCC
BBB
CCC
AAA
BBB

but i'd like it to display like this....

AAA
BBB
CCC

Every programme listed once only.

Any idea's folk's??? :confused:
 
Can't you simply base the rowsource of the combo boxes on a totals query the eliminates the duplicates?
 
Could you explain that please. I'm a complete access noob!
 
Which part, the totals query or setting the rowsource?
 
The totals query please Ken. I'm guessing you set the row source from the properties box.

Thanks!
 
Just do a new query and bring down the field you want to use. Then right click in the query grid and select 'Totals'. Then in the 'Total' row in the query grid, make sure it's set to 'Group By'.

Make sense?
 
I've done that and I've got my list. Thanks! But now the subform is not filtering by the selection i make. I choose AAA and nothing happens! :(
 

Users who are viewing this thread

Back
Top Bottom