I have a form that loads a table: RUNCOST The User enters an Episode# (they choose from a LookUp ComboBox on table EPTOTALS). The next field that the User must enter is Set#. I would like them to choose using another LookUp CombBox, choosing the Set # from table BUDGET where the Episode# they just entered matches an episode# in the table. I'm not sure where, or how, to enter the Where clause. So far, I keep getting my DBComboBox populated with all of the Set#s in the table. Episode 1000 contains set #s 1-99, Episode 2000 only has set#s 1-9. If the User has chosen Episode# 2000 in the field just before, I don't want him to be able to choose Set# 55. thanks, Lin
