Hi Everyone,I have a question about updating main form value into sub-form. The background is:
Main form:
ComboboxA (01-10)
SubformB
TextboxC
Sub-form (01 - 10):
TextboxD (Difference control name in 01-10, but standard, say 01remark, 02remark, 03remark etc...):
Depends on value selected in ComboboxA, one of the subform 01-10 will be called out. Here is my code:
Code:
With Child01
If ComboboxA <> "" Then
.SourceObject = ComboboxA
Else
.SourceObject = ""
End If
End With
Since I do not set a fixed subform, I cannot set Textbox C = TextboxD.
Would anyone help on this problem?
Thanks in advance!