Combobox linked and requery

[Rishi]

Hi.
I have a (maybe small) problem with my form.
This is the case:
Table dept. containing 2 values (dept1 and dept2)
Table Team containing 4 values:
team 11; dept 1
team 12; dept 1
team 21; dept 2
team 22; dept 2
Table Empl.
Table Scedule.

There is a form (continuous form), where the scedule of the empl. can be
specified.
On this form there are comboboxes:
combobox1 linked to table dept.
combobox2 linked to the table team. This combobox is being filtered based on
the first combobox (select(query) and requery(macro); this works fine)

This is what I want to do:
Scedule the employee for different depts.
so
on 11-1-2008 i want to specify dept1 and team 11
on 11-2-2008 i want to specify dept 2 and team 21

This is what happens:
when specifying the 11-2-2008, I select in combobox1 dept2.
and in my cont.form the data for 11-1-2008 the team (team 11) disappears
(the combobox2 goes blank)
If I'd select dept 1 for 11-2-2008 the vaule (team 11) reappears.

How can i design the form in such a way that only the combobox for 11-2-2008
is being affected?

Thanks in advance!