Form's OrderBy not work

[uoghk]

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:

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

[davegri]

Change your recordsource (yellow on your image):
Select * From Register Order By Mobile

Alternately, you might try what you have, but remove the quotes from "Mobile"

[uoghk]

Thanks davegri.
I use your suggection to change the recordsource to "select * from register", then it works.