Synchronized Comboboxes

[Echilon]

I have two comboboxes on a nested form. I've linked the outer form to the comboboxes, so when an item in either is selected the inner form selection changes.

The two comboboxes are showing different fields from the same table (I want to select by either ID or Name). How can I synchronize the selection, so when the user selects a new ID, the corresponding title will also be selected? I've tried VB but my VB rates just above my FORTRAN.

 

[pbaldy]

This type of thing, which presumes both are bound to the number field?

Private Sub cboAcctName_AfterUpdate()
  Me.cboAcctNum = Me.cboAcctName
End Sub

Private Sub cboAcctNum_AfterUpdate()
  Me.cboAcctName = Me.cboAcctNum
End Sub

 

[Echilon]

Cheers. That solved it.

 

[reham]

Echilon, how did you get the combo boxes to synchronize? i cant seem to reference the nested subform to synchronize the combo boxes