chrisjames25
Registered User.
- Local time
- Today, 15:35
- Joined
- Dec 1, 2014
- Messages
- 401
HI
I have a form with a suform within it. I have a command button in the parent form that i want to use to remove sort from the subform. I originally had this button in subform but for look and fell i think best in parent form.
Code i am using for remove sort in effect just applies the orginal sort back ot the subform:
Do i need to set the focus back to a control in the subform before running the above code or is this not right approach?
I have a form with a suform within it. I have a command button in the parent form that i want to use to remove sort from the subform. I originally had this button in subform but for look and fell i think best in parent form.
Code i am using for remove sort in effect just applies the orginal sort back ot the subform:
Code:
DoCmd.SetOrderBy "Category ASC, Genus ASC, Variety ASC"
Do i need to set the focus back to a control in the subform before running the above code or is this not right approach?