Lookup and fill in fields from one table to another using a combo

[Guest]

I've created two tables; Company Info and Editorial Coverage.

I'm trying to link the Company name, address, city, state, and zip from my
first table (Company Info) to my second table (Editorial coverage). I've
created a combo box that pulls the value from one field in my Company Info
table but i can't get the other fields to automatically fill in the values.

What am I doing wrong? It's been almost 12 years since I last created a
database or did any formatting. I need a refresher course!

 

[Guest]

Look at comboBox Properties, Format tab.
Set ColumnCount to 5.
I assume you already set RowSource in Data tab to the query that lists 5
fields you've mentioned.

 

[Guest]

I knew I missed a step. Thanks!

Look at comboBox Properties, Format tab.
Set ColumnCount to 5.
I assume you already set RowSource in Data tab to the query that lists 5
fields you've mentioned.