Multiple selections in List or Combo

[Yvonne]

We have a Contacts database which categorises our Contacts by three
categories eg Country, Language and Skills.
It has a combo box ( not bound) which is populated from a union query
that gets its values from the 3 category fields. At present the
after-update event on the combo box generates a report which selects
those contacts matching the combo selection.

Now, as you might have guessed, I want to get a report which is based
on contacts matching multiple selections. This would be on the basis of
AND not OR from the selections eg find those in the USA who speak
French and who are Doctors

Is this possible without getting into yarsd and yards of VB code?

Yvonne

[ruralguy via AccessMonster.com]

ComboBoxes do not have the MultiSelect feature. You need to use a ListBox.

Yvonne wrote:

>We have a Contacts database which categorises our Contacts by three
categories eg Country, Language and Skills.
It has a combo box ( not bound) which is populated from a union query
that gets its values from the 3 category fields. At present the
after-update event on the combo box generates a report which selects
those contacts matching the combo selection.

Now, as you might have guessed, I want to get a report which is based
on contacts matching multiple selections. This would be on the basis of
AND not OR from the selections eg find those in the USA who speak
French and who are Doctors

Is this possible without getting into yarsd and yards of VB code?

Yvonne

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com