Combo box selection updates multiple source fields in underlying t

I have one combo box with six columns. One value is tied to the underlying
table. I want people to choose from the combobox, and have ALL 6 underlying
fields updated according to the combo box selection. It updated the one field
that has the underlying field as the record source, is there anyway to tie
the remaining 5 columns to the underlying table?
Currently, the combobox relies on a seperate table that populates its values
(a lookup table more or less), but each field in the seperate table does have
a corresponding field in my main table.
I did the =column5(or whatever column) and got it to display the correct
info for each column field in the form, but that doesn't affect the
underlying table.

Hope I didn't make this overly complicated...thanks for your time.

Paul

On Tue, 16 Feb 2010 13:50:10 -0800, Paul
wrote:

I have one combo box with six columns. One value is tied to the underlying
table. I want people to choose from the combobox, and have ALL 6 underlying
fields updated according to the combo box selection.

Why?

It sounds like you're trying to copy five fields from a lookup table into your
main table. This is a VERY bad idea; it would be redundant! If you need to see
the lookup table fields in conjunction with your main table, you can just
store the numeric ID (the combo's bound column), and use a Query joining the
two tables as the basis for a form, report, export or whatever else you need.

If I'm misunderstanding please explain the reason that you need to copy data
that already exists in one table... into another table.
--

John W. Vinson [MVP]