By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Combo Box problem

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.