The combo box won't do it, just the Bound Column will be written. However,
it is possible to do. The questions though is, Why? You should simply be
able to add the table with the two fields to any query that you want the
area for and link it to the main table on the name field. You could then
choose the area field as one of the fields returned by the query.
Also, Name is a reserved word and my cause you problems. You should change
the name of this field to something else, such as FirstName, PartName,
RoomName, etc.
--
Wayne Morgan
Microsoft Access MVP
<paul> wrote in message news:ok********************************@4ax.com...
Hi Group
I am trying to create a combo box from a table with 2 fields Name and
Area. The Combo box is set up to select the name as a dropdown list
which then puts that name into the main table. Is there any way of
getting the combo box to also write the Area into the main table when
selecting the name.
I hope I have explained this alright
TIA