M
Matt
I'm not completely sure what you are looking for here.
If you need to have the text of a textbox equal to the
second column of the combo box, then you just have, in code:
me.[txtboxname] = me.[cboboxname].column(1)
-remember to leave out the "[]'s" and that the first column
is column 0 and the second is column 1 (and so on) for a
list box or text box.
I'm not exactly sure, however, why you have 2 tables with
duplicate information. If you are going to have an ID for
the department, it needs to be in the department
information table. If table "A" as you called it, is the
table you are inputting the information to, then it does
need it's own table, and I am mistaken. Otherwise, you
need to merge these two tables into one.
If you need to have the text of a textbox equal to the
second column of the combo box, then you just have, in code:
me.[txtboxname] = me.[cboboxname].column(1)
-remember to leave out the "[]'s" and that the first column
is column 0 and the second is column 1 (and so on) for a
list box or text box.
I'm not exactly sure, however, why you have 2 tables with
duplicate information. If you are going to have an ID for
the department, it needs to be in the department
information table. If table "A" as you called it, is the
table you are inputting the information to, then it does
need it's own table, and I am mistaken. Otherwise, you
need to merge these two tables into one.