I have five tables in access database. and five types of data entry form in vb6.
Table1 contains several fields. First field is "Name of the company"
All tables have several fields but the first field of all the table is "Name of the company"
Data to table1 is saved through form1
Data to table to is saved through form 2 and so on.
Name of the company can be entered through form 1 only ie if an new company is reqiured to be entered then the same can be done through form1 only.

As other form also needs name of the company so I have added a combobox to every form for the field "Name of the company"

Now I want to display the name of the company in the combox box1 of form 2 ( for all forms except form 1) from the field 0 (ie the first field) of table 1
how can I do so?