Combo box help needed

[Debbiedo]

I have created a combo box on a data entry form (DataForm) that
references another table (LUT_Table) in the same database to populate
the list. When I select a name from the list, I want to populate two
fields from the referenced table (LUT_Table) into the table
(TargetTable) linked to the form. How can I do this?

TargetTable fields:
ID (Linked field in Access)
Name

LUT_Table fields:
ID (Linked field in Access)
Name

The record source for DataForm is TargetTable. TargetTable Combo list
on DataForm references LUT_Table and populates TargetTable.ID with
selected LUT_Table.ID

How can I also populate TargetTable.Name with associated
LUT_Table.Name and have it display on the form right after the ID was
selected from the list?

Clear as mud, right?

Thanks in advance.

BTW, I know the info is redundant and appears to be poor database
design, but for reasons I do not want to go into, it has to be this
way.

Deb

 

[Guest]

Include the field in the recordsource of your combo.
Set the column count to 2 and the column widths to e.g. 0cm;2.5cm (use
values that match your measurment type).

In the Name field on your form, set the controlsource to:
=MyCombo.Column(1)

Steve