Forum Discussion
Populating a field based on another field's information
Hi, I have a postal code field. With that postal code, I want to be able to fill in another field with the area of the city that correlates with. For example, TZN is North Edmonton. Is there a way t...
I would set the Row Source of the Three digit PC-combo box to:
SELECT [Three Digits PC], [City Location] FROM [Area of City];
And in VBA the Three_digit_PC_AfterUpdate subroutine to:
Me.Area_of_City.Value = Me.Three_digit_PC.Column(1)Since City Location is the value you want and it's now the second column (with index 1).
Hope this work. Good luck.
