combo box question

[Lieu]

Hello there,

I have table1, table2, a combo box. table1 has field1, table2 has field1 and field2. When the form load, the combo box is bounded to field1 of table1.

Question: Although the combo box is bounded to field1 of table1, is it possible to have the combo box populate information from field1 of table2. And then when comes to save the record, I would like it to save the information from field2 of table2 to field1 of table1.

I am using access 97 for table1 and table2.

Thank you in advance.

Hai Lieu

[Geekabyte]

try this. just remember the name of the field's name has to be da same in both tables

combo1.rowsource="SELECT field1 FROM table1, table2"