I know this is posted a lot but for some reason I can't seem to figure out what is wrong with my code.
Private Sub Location_AfterUpdate()
Me.LocState = Me.LocCity.Column(1)
End Sub
All I am trying to do is auto populate the state after the city has been entered.
The city combo box is based off a lookup table with the city and state as fields.
Am I missing a step somewhere?