J
Jen27 via AccessMonster.com
Hi Access Gurus.
I'm just learning, so please forgive my ignorance.
I have a form with fields called "Person Contacting" and "Area" (amoung
others). The Person contacting field is currently a combo box linked to a
table "Contact Names".
The "Contact Names" table has two columns 1 = "Name" and 2 = "Area".
I'd really like to be able to be able to pick the name from the combo box in
the "Person Contacting" field and have the "Area" field automatically filled
in with the corresponding contents from column 2 ("Area") in the "Contact
Names" table.
The table behind the form needs both to be filled in, however neither are
primary keys.
Thanks,
Jen
I'm just learning, so please forgive my ignorance.
I have a form with fields called "Person Contacting" and "Area" (amoung
others). The Person contacting field is currently a combo box linked to a
table "Contact Names".
The "Contact Names" table has two columns 1 = "Name" and 2 = "Area".
I'd really like to be able to be able to pick the name from the combo box in
the "Person Contacting" field and have the "Area" field automatically filled
in with the corresponding contents from column 2 ("Area") in the "Contact
Names" table.
The table behind the form needs both to be filled in, however neither are
primary keys.
Thanks,
Jen