I am new to access and did not understand Lynn's comment earlier.
Hopefully
you can help.
I have a lookup table (lu_master) with fields: Primary (unique key),
Scientific, and Common.
In a form (frm_Incidental) I have 2 combo boxes: txtScientific and
txtCommon
that use the lookup table above to give the user options to pick.
What I want to do is: if the user selects an option in the txtScientific
field the txtCommon field will autopopulate based on the value found in
the
Common field in the lookup table. If the user leaves txtScientific blank
and
selects a value for the txtCommon field, the txt Scientific field will
autopopulate based on the value found in the Scientific field in the
lookup
table.
I know I have done this in the past but can not remember how. Thanks for
the help.
