How to bind a control of main form to subform field
Explanation:
In Access 2010 I've made a Main form1 with a linked subform1 (the subform1 linked using “Link Child Fields, Link Master Fields”).
In form1 I’m able to select records from a query and display related records in subform1.
My question:
Is it possible to bind a control (Text Box) of form1 to “subform1 field” to be able not only to display*, but also to enter and update values for the records selected in subform1.
Or I can only bind control to fields in the “Record Source” of the Form on which this control (Text Box) resides. In this case I'll need a help finding a solution of my problem:
I'm making a foreign language dictionary where 1 record (selected in form1) has several related records (displayed in subform1) and I need to be able to view and edit this related records enlarged in Text Boxes of main form1 (especially "Memo" fields with several lines of text).
* - I'm able to display subform1 value in form1 control by writing Control Source:
But in this case I got an alert (error) on the Access status bar:
"Control can't be edited; it's bound to the expression ..."
Explanation:
In Access 2010 I've made a Main form1 with a linked subform1 (the subform1 linked using “Link Child Fields, Link Master Fields”).
In form1 I’m able to select records from a query and display related records in subform1.
My question:
Is it possible to bind a control (Text Box) of form1 to “subform1 field” to be able not only to display*, but also to enter and update values for the records selected in subform1.
Or I can only bind control to fields in the “Record Source” of the Form on which this control (Text Box) resides. In this case I'll need a help finding a solution of my problem:
I'm making a foreign language dictionary where 1 record (selected in form1) has several related records (displayed in subform1) and I need to be able to view and edit this related records enlarged in Text Boxes of main form1 (especially "Memo" fields with several lines of text).
* - I'm able to display subform1 value in form1 control by writing Control Source:
Code:
=[subForm1].[Form]![fieldName1]
"Control can't be edited; it's bound to the expression ..."
Last edited: