Combo box limits combo box

[Guest]

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

 

[Guest]

hi,
cascading combos
http://www.rogersaccesslibrary.com/TableOfContents3.asp
http://www.blueclaw-db.com/filter_combo_box.htm
http://www.mvps.org/access/forms/frm0028.htm
http://www.pacificdb.com.au/MVP/Code/ComboRS.htm