Auto-fill in datasheet

[Terence]

No doubt this question has been asked before - but I'm unable to trace an answer.



When I enter a town or suburb name in a data sheet field I want the corresponding post(zip) code to be automatically inserted in the appropriate field.

I have a combo box from which I select the town/suburb and a table containing the towns/suburbs with corresponding post(zip) codes.

Thank you

[RuralGuy]

You can use the AfterUpdate event of the ComboBox to copy any of the columns of the ComboBox to your other controls.

[Rick West]

Posted a relpy when I wanted to ask a new question.