dynamic combo boxes?

[1jet]

Hi all,

My form frmEmployeeTimesheet has 5 similar combo boxes.
Similar in that they all have a drop down list of projects to choose from.
cboSelectProject1 has it's row source as...

SELECT tblProject.[Project ID], tblProject.[Project Name] FROM tblProject;

Currently cboSelectProject2, 3, 4, 5 all have the same select query as its row source.

My question is, is it possible for cboSelectProject2 to have its choices MINUS cboSelectProject1.

And, cboSelectProject3's choices minus (cboSelectProject1 + 2)
And, cboSelectProject4's choices minus (cboSelectProject1 + 2 + 3)

...and so on?

Basically if it's chosen in a previous combo box, I don't want the following combo boxes to show the already chosen options.

Thanks.

 

[1jet]

found the solution...
my 2nd combo box's code is...

SELECT tblProject.[Project ID], tblProject.[Project Name] FROM tblProject
WHERE (((tblProject.[Project ID])<>[Forms]![frmEmployeeTimesheet]![cboSelectProject1]));