Combo Box problem

[paul]

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

[Wayne Morgan]

Re: Combo Box problem

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:ok3mi01efq t3l5v3569k4cbvb t13okuo1e@4ax.c om...[color=blue]
> 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[/color]