[newbe]

Hey everyone, I'm pretty new to Access, and I've been learning it by doing I suppose. Up until this point, everything has gone well. There's just one thing I can't figure out. How do I make a field automatically populate with say "the...

Hey everyone,

I'm pretty new to Access, and I've been learning it by doing I suppose. Up until this point, everything has gone well. There's just one thing I can't figure out.

How do I make a field automatically populate with say "the address of a business" based upon a selection from a droplist containing all the business names?

So say I choose 'ABC Inc.' as the business.

I want the address field below to automatically populate with

123 Main St.
Somewhere, USA

Is this possible to do without extensive coding?

Thanks in advance for any help!