Combo box values put into a text box (1 Viewer)

[david.paton]

I have a combo box to select the town on the form frmCarers. I want a 2 text boxes below, txtstate and txtpostcode to be automatically updated when I select a town. I also need them to not disappear if I am to close and open the form.

 

[david.paton]

I worked it out. I just put the following code on the after update event from the combo box and in the on form load event.

Me.txtPostCode = Me![cboTown].Column(2)
Me.txtState = Me![cboTown].Column(3)