Hey all

i have a combo box called cboSiteSub and a text box called post_code
i have a table linked to the combo box with two columns "Suburb" and "postcode" i have been able to get the postcode to appear in the postcode textbox when the corrosponding suburb is selected.

i used this code:

Private Sub cboSiteSub_AfterUpdate()
Me.Post_Code.Value = Me.cboSiteSub.Column(1)
End Sub

this all works fine. but now i want to reverse it aswell so if the postcode is typed in the text box, the corrosponding suburb is entered

Hope this makes sence

Thanks in advance

Private Sub Post_Code_AfterUpdate()
Me.cboSiteSub = Me.Post_Code
End Sub

???

mmcdonal