Thanks to both of you for your help so far. Maybe to help explain it better, the way I had initially set this up many, many versions ago and the way it used to work was upon creation of a new record, I tabbed to the Company Code field and I entered the specific Company Code I had assigned for each clients company that they worked for, upon doing that it automatically populated the address field with that client's company address and ALSO populated the Company name field with the company's full name; all based on the acronym I used for that client's code. Set up like that all I had to do was enter a few initials in the Company Code field and it filled out the other two fields sparing me having to type all that info in. Somewhere along the way, whatever happened, it now populates the address field with the company code and not the address. However, it does correctly fill in the company name field with the company name so it's only the address field as it relates to the company code field that, to me, is broken.
Many thanks again for your help with this and more importantly for your time. Much appreciated.