Make one combo list depend on another (1 Viewer)

[guinness]

Aaaaargh!!!!

I hope someone can help. I've done this a million times and it always gives me grief.

I have a combo: cmb_TrainingType. The sql is:

SELECT tblTrainingType.TypeID, tblTrainingType.Type FROM tblTrainingType ORDER BY tblTrainingType.Type;

My second combo (the one that should be filtered based on the Type chosen above) is cmb_Project_Title. The sql I have written (which isn't working) is:

SELECT tblCourseDetails.CDID, tblCourseDetails.Project_Title FROM tblCourseDetails WHERE (((tblCourseDetails.TypeID)=Forms!frmResourcing.cmb_Training_Type) And ((tblCourseDetails.Type)=Forms!frmResourcing.cmb_Training_Type)) ORDER BY tblCourseDetails.[Project_Title];

Both of the tables that are referenced have the fields TypeID and Type.

I'm really hoping someone can point out the error of my ways.

Cheers

 

[XV1957]

Is it normal that you are using Forms!frmResourcing.cmb_Training_Type) in your second combo. Should the first = statement not refer to training_typeID?