My requirement is:

In the form, find a record in table A by SSN, display several fields on the form with data from table A. Have several other fields on the form that data is then keyed into. Add a new record to table B with all the fields from the form. Can this be done? Can there be more than 1 source for a screen. All ideas welcome. Thanks Tom

You use queries to combine data from more than one source. Depending on what you are doing here you may want to set up these two tables in a One to Many relationship. If that is the case then a form/subform approach would probaby be the best.