Combo Box REFRESH (query dependent)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top