Automatically select combo box row

[Tony]

I have two synchronized combo boxes. When I make a selection from box 1 I
want box 2 to automatically select the first row of the updated list (so it
stays in sync). I'm using Access 2003 VBA.

Thanks,

Tony

 

[Marshall Barton]

I have two synchronized combo boxes. When I make a selection from box 1 I
want box 2 to automatically select the first row of the updated list (so it
stays in sync). I'm using Access 2003 VBA.

In combo1's Afterupdate event procedure, add a line like
this right after the combo2.Requery:

Me.combo2 = Me.combo2.ItemData(0)

 

[Tony]

Thank you!

In combo1's Afterupdate event procedure, add a line like
this right after the combo2.Requery:

Me.combo2 = Me.combo2.ItemData(0)