Cascading combo - fields keeping value from previous entry

[visionstate]

Hi All,
I have a few tiny problems left with my cascading combo boxes.
Here is what my form looks like:

http://img219.imageshack.us/my.php?i...aseformwl5.png

The way it works is by filtering by previous entries. So for instance,
if I Choose Admin from the Department then I get the selection of teams
from that Department. When I choose a Team, I get the list of Surnames
from that Team and so forth.

Everything is fine until you get to the Forename field. If I fill in a
value for Department, Team, Surname and then Forename and then get the
results in the report, then it works perfectly. If I then go back to
the form and again enter a Department, Team and Surname, the Forenames
do not filter by the Surname entered and instead it just displays the
previous entry I used. This is the same for the following combo boxes
as well.

Any ideas why this is and any ways around it?

Many Thanks,

Rob.