Data Entry with texboxes

[nocolo]

I have a form which contains a subform and several textboxes. The textboxes control source is the columns in the subform. The subform's record source is TableA. The main form's record source is TableB. When you change the focus in the subform from one row to another by clicking the right side of the subform, the textboxes associated with the subform also change to reflect the new values focused in the subform.
that works fine, what I'm having problems with is I would also like to use those same textboxes to update or add values taken from the subform and save the edited values back the the Subform Record Source TableA. The way it's set up presently I can't do that because it says that the control is bound to the expression pointing it to the subform column. I can move the texbox control to the Default Value but then the textbox only updates upon opening the form. I have tried to create a macro to update the textbox but I'm not sure under which event or which object to put it in.
Can anyone help me to see the light. I have been fighting with this problem all day. Any help you can give would be greatly appreciated.
chris

 

[David R]

If the records in the subform are bound, why are you trying to update them from the main form? Seems like more trouble than it is worth, unless I'm misunderstanding what you're asking...

You should be able to go to the subform and update them there. The fields in the main form should NOT be allowing you to update, otherwise you are storing the same data in two places which will cause you problems anyway.