Forms

I

Ian

I was wondering how I make one field equal something in other feild on a
form i.e.

I want too enter in a town in one filed and the post code/ zip code is
automatically enter into the zip code field.

Can anyone help thanks

Ian
 
J

John W. Vinson

I was wondering how I make one field equal something in other feild on a
form i.e.

I want too enter in a town in one filed and the post code/ zip code is
automatically enter into the zip code field.
Click to expand...

Which Zip code would you want entered if the town were Los Angeles? There are
101 of them. Many towns have multiple zip codes.

If that's not a problem in your area you can use a Combo Box to select the
city from a table containing both city name and postcode; in the AfterUpdate
event of the combo you can "push" the postcode into the desired field.

Private Sub cboCity_AfterUpdate()
Me!txtPostcode = Me!cboCity.Column(1)
End Sub

will set the postcode textbox txtPostcode to the value in the second column of
the city combo's row source.
 
Top