Forum Discussion

oinorton's avatar
oinorton
Copper Contributor
Sep 18, 2020

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...
access
oinorton's avatar
oinorton
Copper Contributor
Oct 19, 2020

Woldman 

I put it the following code and I'm getting an error. Can you see anything wrong with it?

Woldman's avatar
Woldman
Iron Contributor
Oct 20, 2020

oinorton 

Could you post a print screen of the error?

  • oinorton's avatar
    oinorton
    Copper Contributor
    Oct 20, 2020

    Woldman The error isn't coming up any more but it's not working. Below is my Property sheet for the Postal Codes. Do I have this right?

     

    • Woldman's avatar
      Woldman
      Iron Contributor
      Oct 20, 2020

      oinorton 

      In this case you should use Me.Three_digit_PC.Column(0) since Area of City is the first column and the index starts at 0 (zero). 

      • oinorton's avatar
        oinorton
        Copper Contributor
        Oct 20, 2020

        Woldman

        I'm getting closer!! I really appreciate your help!

         

        Here is my table:

         

         

        Here is my coding:

         

        This is my form:

        What I want is the Area of City to show up in the Area of city field but the Postal code is showing up instead. I've played with the coding but I'm not getting it right. 

        Thanks in advance. 

Resources