Requery problem with combos on a continuous subform

Hi There,
I have posted an earlier post today, far too complicated by the looks of it,
so I have re-written a simplified version.
I am new to this and I really need some help, I have looked and read lots of
posts, but I still cannot get it!
I have 3 dependent cascading combo boxes in a subform, which is also
continuous.

I can select data from the first combo box, but the
second combo box which depends from the first is blank, the third combo box
which depends on the second combo is showing data but there is no selection
to it, just the whole list.

Combo 1: CboInjuryID based on TblInjuries:
InjuryID: AutoNumber, PK
InjuryName

Combo 2: CboMBodyPartID based on TblMainBodyParts:
MbodyPartID: AutoNumber: PK
MbodyPart: Text
InjuryID

Combo 3: CboBodyPartID based on TblBodyParts:
BodyPartID: AutoNumber: PK
MbodyPartID

What I am trying to reach is to have the combo boxes working on a continuous
form and finally to connect this subform to the main form.
I have been trying for days to no avail and I am feeling very confused now.
Any help would be greatly appreciated!
Chris.

.

Relevant Pages