Greetings,

In a nutshell, what I'm trying to accomplish is the have a user select a
unique value from ComboBox1 and then have ComboBox2 bring up the associated
value(s).

Setup:
The values in ComboBox1 are unique and reside on Table1.
The values in ComboBox2 are unique and also reside on Table 1. (The values
are names and account #'s respectively).  All of the selected info and
additional user provided info will populate Table2.

Also, because both values are associated with each other and are unique, I
can set up a ComboBox to populate a TextBox if that is easier. Whatever you
helpful Access gurus can recommend would be helpful.

Thanks in advance,
DK