3 cascading combo boxes on a continuous subform (Version 2K)

[Chris]

My problem is to have 3 dependent cascading combo boxes working in a subform,
which is also continuous.

The form is designed and 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
whixh depends on the second combo is showing data but there is no selection
to it, just the whole list. I have also attached my database, as it might be
easier to see what I am doing wrong.

My tables are as such:
TblInjuryRecordsJunction: Record source of the subform: FrmInjuriesSub
InjuryRecordID: AutoNumber, PK
InjuryID: FK
RefNumber:FK
InjuryLevelID: FK
MbodyPartID: FK
BodyPartID: FK

TblInjuries: For Combo 1: CboInjuryID
InjuryID: AutoNumber, PK
InjuryName

TblMainBodyParts: For Combo 2: CboMBodyPartID
MbodyPartID: AutoNumber: PK
MbodyPart: Text
InjuryID

TblBodyParts:For combo 3: CboBodyPartID
BodyPartID: AutoNumber: PK
MbodyPartID

TblAccidentRecords: Record source of main form: FrmAccidentRecords
RefNumber: PK

Any help would be much appreciated!
Chris.

 

[KARL DEWEY]

Are you refreshing the query for the second after making the selection for
the first?

 

[Chris]

Hi Karl,

This is what I have in the first combo:
Private Sub cboInjuryID_BeforeUpdate(Cancel As Integer)
[Forms]![FrmAccidentRecords]![FrmInjuriesSub].[Form]!CboMBodyPartID.Requery
End Sub