Populate one field in a form based on value entered in other field

[Tracey]

I have a mailing list form bound to a table called "mailing list." The
mailing list table has several fields, and two of them are "county" and
"grand division." I have a second table called "counties" with two
fields - "county" and "grand division".

For the County input on the form, I have a combo box with values from
the County field of the Counties table. I need the form to look up in
the Counties table and populate the "Grand Division" field in the form
based on the input in the "county" field.

Can this be done without SQL or VB programming? Isn't there some way
to do it in the form design view? I've been editing the "grand
division" text box in the form design, but I can't seem to find a way
to tie it to the "counties" table and to force it to plug in the value
that corresponds to whatever is put in the Counties field.

I hope this wasn't too confusing. Thanks!


Tracey

 

[Guest]

-Bound your form to a query where your table "mailing list" is joined to
table "counties" using field "county" and include the field "grand division"
from "counties" to display in a locked(properties/data/locked=Yes) text box
in your form
-Every time you select a county with the combo box, the grand division will
be displayed, and you are not duplicating data in 2 tables,
-Eliminate the field "grand division" in table "mailing list", this is also
a good table normalization practice,
-For all your reports where "grand division" is needed, simply join your 2
tables to get this information

 

[Tracey]

Thanks!



Tracey