Using forms to populate multiple tables

[Geocink]

How/where do I solve this on a form?:


What I want to do is select "Manufacturer" or "Vendor" in the SupplierType combobox on the SupplierInformation form and then have the CompanyName typed into the next field also go into the ManufacturerTable or VendorTable, respectively.

Thanks in advance for your help.
G

[Ruegen]

You can use VBA to do an after update event

so if you select 5, it pulls in the second column (can be hidden) of the combo box

you can then have your field = the column

say

me.ControlTextBox = me.combo.column(3) *note whatever the column is in the combo box, the number should relate. And they start from 0 not 1.