filtered combo box

[Lifeseeker]

Hello,

Could someone point me in the right direction?

I have a form that has 2 dropdown combo boxes.

Users would like to select from the filtered recordset from the combo box based on the previous combo box selection. I have a test copy set up, but it's partially working.

As you can see in the file I've attached, the 2nd combo box, which is the issue_initative, is showing nothing when the category combo box has been selected. The query for the initiative combo box is this:

SELECT junction.issue_initiative, junction.Issue_category
FROM junction
WHERE (((junction.Issue_category)=[forms]![TEST JUNCTION]![issue_category]))
ORDER BY junction.issue_initiative;


help much appreciated.

 

[pbaldy]

You have to requery the second combo in the after update event of the first.