Hi I am banging my head against the wall over this one. I have an
unbound combobox on a form from which I want to be able to see the
various years for which we attended a particular trade show. What I do
is select the trade show name from a drop down and then I want the
years that we attended that show to automatically dropdown when I
select the Year dropdown. I use the same form to enter the events as I
do to edit them. What I cant figure out is the SQL necessary to
populate the year dropdown without getting multiple values in the show
name drop down.

Hope this makes sense

Colin

Colin
Code the Combo Box Exit event:
[OtherCombo].RowSource = "Select AttendYear from YourTableName Where
YourTableName.Event = " & Me.ThisComboName

A Selection in the first combo will be filtered in the second.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


"Colin Ward" <cward002 (AT) sympatico (DOT) ca> wrote