I only set a form's Record Source to a table "Register" as below photo, and no other settings.
I then code a "Refresh" button to filter by a date and order by mobile no. as below:
Code:
Me.Filter = "ReDate=#" & Me.ReDate & "#"
Me.OrderBy = "Mobile"
The result screen as below:
The Filter is OK, it shows all records on request date.
But the Order does not work, it does not sort by Mobile no.
I also try to set Me.OrderBy="PatientNo DESC", it also show the same order as in above photo.
It seem that it always show the current order, no matter how I set the Me.OrderBy
Thanks