Hi,
I have form with a subform. On my main form, there is a field "language", so I would like to dynamically manipulate all label associated to the field in the subform to change depending on the language chosen in the main form.
Here is my code for a single field, but I want to be able to loop through all field within the subform:
Any help is appreciated.
Thanks
I have form with a subform. On my main form, there is a field "language", so I would like to dynamically manipulate all label associated to the field in the subform to change depending on the language chosen in the main form.
Here is my code for a single field, but I want to be able to loop through all field within the subform:
Code:
If Nz(Me.txtLang) = "English" Then
Me.subform.Form!leg_ent_nm_lbl.Caption = Nz(DLookup("txt_label", "label_fld_t", "txt_fld = """ & Me.subform.Form!leg_ent_nm.Name & """"))
Else
Me.subform.Form!leg_ent_nm_lbl.Caption = Nz(DLookup("txt_label_fr", "label_fld_t", "txt_fld = """ & Me.subform.Form!leg_ent_nm.Name & """"))
End If
Thanks