Combo Box Value To Automatically Put Value From Different Variable Into Text Field

I have requested this before but the example given did not fit my situation and I had a heck of a time trying to adapt the example given to me so I will step by step describe what I need. thanks...


Can someone show me how to do the following:

1) Take a combo box that looks up a table that has 2 variables (Var1 and Var2).

2) Depending on the value chosen in the combobox (Var1) then a text field will automatically have the value (Var2) appear.

3) This information from combo box and text field will then be stored in a separate table that is linked to the form.

__________________________________________________ _____________

Also:

Is there a way to extend this example further by adding another combo box that takes the result from the first combo box to filter in values for the second combo box which will then automatically populate a text box which would then be stored in a separate table.

__________________________________________________ _____________

Someone kind of showed me before but they used unbound variables and this confused me as the combobox was unbound but how is that information stored into my table?

Pardon me for my redundancy but this is frustrating me to no end and I unfortunately have a deadline of today!!!! :(

I think it is the row source thing that confuses me. I take row source to mean where the data is stored. But where do you identify where to obtain the data to then store in your "inputed" table?