Source table to populate another table

[Squid]

I have two tables. Table1 contains a lot of information
about my members (EmpID, name, etc). Table2 is a general
table that will have certain fields from Table1, plus
other information manually inputted

I want the user to be able to select a member from a
combobox record source being table1, then have certain
fields to be displayed on the form then also populate
Table2. The user will also enter additional fields into
table2 from the same form.

 

[John Vinson]

I have two tables. Table1 contains a lot of information
about my members (EmpID, name, etc). Table2 is a general
table that will have certain fields from Table1, plus
other information manually inputted

I want the user to be able to select a member from a
combobox record source being table1, then have certain
fields to be displayed on the form then also populate
Table2. The user will also enter additional fields into
table2 from the same form.

This may not be the best design.

Storing the same data redundantly in two tables is almost never a good
idea. In a relational database you store data *ONCE*, and then use
queries to link to it.

I'd suggest instead having the second table contain *only* the EmpID
from Table1, as a foreign key, plus whatever other fields you need.
You could then create a Form based on Table1, with a Subform based on
Table2, using EmpID as the master/child link field. This will let you
display (and enter, and edit) the data from the two tables on one
screen, without storing duplicate data.