Bounding Fields In A Form - Problem

Hello,

I am having trouble bounding form fields that I have created to show data.

In summary:

I created a Form with a bound table that will enable me to scroll thru records. When a record comes up I want to be able to use a combo box to bring up the applicable correponding information based on the record and combo box option chosen. Upon choosing which option I would like from the combo box I would like the default data to come up in the empty fields that correspond to the option I chose in the drop down box. I would also like to input data on empty fields and save the whole record.

Is this feasible?

Thx

PE