Hello,
Can you help me understand this :
I do have in my mainForm a control that gets the value of a control in mySubForm footer:
1 - control [sa], in subforms footer : = Avg(Val([anoMaq]))
2 - control [tAno], in myMainFrom =[frmB].[Form]![sa]
it works fine until I run the following code
wich orders records in my subform by the field anoMaq . after it executes the value in the textbox control [tAno] in MainForm vanishes
I tried to requery both forms after the orderBy, but still with no results
I appreciate your help
Can you help me understand this :
I do have in my mainForm a control that gets the value of a control in mySubForm footer:
1 - control [sa], in subforms footer : = Avg(Val([anoMaq]))
2 - control [tAno], in myMainFrom =[frmB].[Form]![sa]
it works fine until I run the following code
Code:
Me.OrderBy = "[anomaq]"
Me.OrderByOn = True
wich orders records in my subform by the field anoMaq . after it executes the value in the textbox control [tAno] in MainForm vanishes
I tried to requery both forms after the orderBy, but still with no results
Code:
Me.OrderBy = "[anomaq]"
Me.OrderByOn = True
Me.Form.Requery ' to requery the subform
Me.Parent.Requery ' to requery the main form
I appreciate your help