I have a SubForm on a TabControl .. and I would like to force the sort order of the data on the subform whenever I click on that particular tab.
Right now .. I am forced to click on a button to force the sort order. I would like this automatically done .. when I click on that tab.
I have tried to Call cmdSortByUserName_Click .. but it does not seem to like it. But I may have done it wrong.
Subform is subNewRadiosNoTrans
TabControl is TabCtl0
Page is page index 4
Button is cmdSortByUserName
On click of the button is ..
Me.OrderByOn = True
Me.OrderBy = "User DESC"
Right now .. it just stays at whatever the last sort order is (For example User Asc) .. not what I want. I want it always be to User Desc on selection of that tab. (there are several buttons that can change the sort order on the subform to allow different sort ordering as desired).