Popluating data fields

[Brian]

I would like fields in one data table to populate with data
from another data table based on a pull down field. For
example, I'd like the address, city, state, zip fields in
one table to populate with data from the Customer table
based on the Customer Number.

Thanks

 

[Brian]

Perhaps using the Customer table was a bad example. I have
a table that has data from "Heats" that we pour metal from
(it contains chemistry for that particular metal). Each
heat has its own heat number, but we sometimes pour several
different parts from one heat. I want to enter the heat
number and have it fill in chemical numbers from that heat
into a new table. Then I can enter Customer number, part
number etc... for that shipment.

 

[Rick Brandt]

Perhaps using the Customer table was a bad example. I have
a table that has data from "Heats" that we pour metal from
(it contains chemistry for that particular metal). Each
heat has its own heat number, but we sometimes pour several
different parts from one heat. I want to enter the heat
number and have it fill in chemical numbers from that heat
into a new table. Then I can enter Customer number, part
number etc... for that shipment.

Not sure I follow that, but one of the basic ways to do this is to use a
ComboBox to enter the (heat number). Add additional hidden columns to the
ComboBox to pull in all other fields you need from the Heats table. Then in the
AfterUpdate event of the Combo use code similar to. . .

Me!SomeControlName = Me!ComboBoxName.Column(1)
Me!SomeOtherControlName = Me!ComboBoxName.Column(2)
etc..

Columns are numbered starting with zero so Column(1) is actually the second.

 

[Brian]

How do I add hidden columns. As you can tell I have little
experience in Access