populate table with dropdown list selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form with two dropdown lists from two seperate tables. I'd
like to populate a third table with the selection from the drop down lists.
Is this possible? how?
Cheers
 
bind the form to the third table, and set the ControlSource (not the
RowSource) of each combo box control (the formal name of a "dropdown list")
to the appropriate field in the table.

hth
 
Thank you Tina. I am pretty new to this kind of stuff. Where do I go to bind
the form to the table?
 
open the form in design view. if the Properties box is not showing, press
Alt+Enter to show it, or from the menu bar click View | Properties. make
sure the title bar of the Properties box reads as Form. click on the All
tab, and set the RecordSource property to the name of the table, from the
droplist.

if you're not too familiar with Access, recommend you invest in a basic text
that will teach you the correct nomenclature, as well as help you master the
basic skills necessary to build a working database. one such text is
Microsoft Access <version> Bible by Prague and Irwin.

hth
 
Hi tina, the 5 books on access I have don't cover this. The biggest book is
from Microsoft press "Running M/S Access". I look at buying Microsoft Access
Bible by Prague and Irwin. Thank you for the recommendation.

I figured out how to bind the form to the 3rd table but there isn't an
option to set the ControlSource of each combo box control to the appropriate
field in the table.

As I am using two droplist from two different tables wouldn't I need to
create a control to update the third table with the selections from the
droplists?

Mark
 
there isn't an
option to set the ControlSource of each combo box control to the appropriate
field in the table.
Click to expand...

just open the form in design view. click on a combo box control to select
it. in the Properties box, look on the All tab for the ControlSource
property. set the value to the appropriate field in the form's underlying
table, from the droplist.
As I am using two droplist from two different tables wouldn't I need to
create a control to update the third table with the selections from the
droplists?
Click to expand...

no. bind each combo box control to the appropriate field in the form's
underlying table, as i said. set the *RowSource* of each combo box to the
table that contains the field(s) you want to see in the droplist. suggest
you read up on ComboBox controls in Help, including the topics for their
various properties such as RowSource, ColumnCount, BoundColumn,
ColumnWidths, for a better understanding of how they work.

hth
 
Back
Top