Combo Box REFRESH (query dependent)

[Guest]

I have 4 combos on a form and the selection on combo1 filters the query used
in Combo2 etc. I had asked in a previous post on here that I would like to
have Combo2 select the first item in it's list after Combo1 has been updated.

Below is what I have been able to do based on feedback received.

Private Sub Select_BU_AfterUpdate()
Me.[select group].Value = Me.[select group].ItemData(1)

The problem is that after I have made a selection in Combo1 (SELECT BU), I
notice that Combo2 (SELECT GROUP) does indeed select the first item in it's
list, but the list does not change as predicted. It will change the first
time you select something in Combo1, but when you pick another thing in
Combo1's list, the list in Combo2 is not being refreshed.

Can anybody tell me how to REFRESH the list in combo2 anytime the selection
in Combo1 changes; I need to do this for Combo3 dependent on Combo2 etc.

Pele

 

[Steve Schapel]

Pele,

Using a VBA procedure here, and not a macro, you need something like
this before the line of code you posted...
Me![select group].Requery