Combo box requery

[raneking22]

I have a form with 2 combo boxes in it. The first combo box is named combo0 and has as its row source:

SELECT DISTINCT [tsam grouped]!field1 FROM [tsam grouped] ORDER BY [field1];

The second combo box has as its row source:

SELECT DISTINCT [TSAM GROUPED]!field2AS Expr1 FROM [TSAM GROUPED] WHERE ((([TSAM GROUPED].field1)=Forms!form1!combo0));

So basically, the user selects from the first combo box which field1 value they want to limit their returned recordset to. Then the second combo box populates with all unique field2 values for that field1 selection.

My problem is this: This form works only one time, and then the second combo box does not change based on what is entered in the first combobox. I *think* I have this narrowed down to having to do something to the On Get Focus property of the second combo box, but I'm not sure what that is. I just need for the second combo box to recalculate each time the first combo box is changed.

It is quite unfortunate that this form will need to be run more than one time in the history of the universe. Otherwise I would be done with this part already :-)Can anyone help?

Thanks in advance!

[raneking22]

P.S.

Here's what I've tried: Any number of variations of Me!Combo2.requery in On Get Focus Property. (The second combo box is Combo2)

Thanks!

[raneking22]

Nevermind, I got it. Just had to do a module in the On get Focus:
Me!Combo2.Requery.

Blah.

[MMcCarthy]

Nevermind, I got it. Just had to do a module in the On get Focus:
Me!Combo2.Requery.

Blah.

You could also use the Me!Combo2.Requery in the After Update event of Combo0.

Glad you got it to work anyway.

Mary

[NeoPa]

Well done for finding a solution, but don't feel bad about posting.
Mary's answer is an illustration of the correct way of doing it. Your way will have the desired effect but may also cause it to run the code more often than it needs to.
This really should be run only when a selection is made in Combo0.

[NeoPa]

You may find this helps too (Example Filtering on a Form).

[raneking22]

Mary/NeoPa,

Your afterupdate solution in the first combo box causes the 2nd combo box to populate much, much faster than the ongotfocus (on the 2nd combo box) way I was trying.

Thanks!

[NeoPa]

We're glad we were able to help :)