Split Form Not Honoring Select Statement

[JamesJ]

I have a split form with 2 fields showing. The Record Source is:
Select * From tblDvd ORDER BY Title, MovieType
While the form was in form view I selected the drop down from the column
header
for the DvdID field and selected 'Sort form smallest to largest.
It sorted ok but now I'm stuck with that sort. I double checked the Record
Source and it
remains Select * From tblDvd ORDER BY Title, MovieType. The form was fine
before.

Why won't this change back?
I'll need to import the form from a backup. This is becoming a habit with
Access 2007.

James

 

[June7 via AccessMonster.com]

Was anything saved in the forms's OrderBy property?

 

[AccessVandal via AccessMonster.com]

You can't modify the RecordSource SQL string that way the in Access Menu.
You'll have to create a custom button to filter the modify RecordSource
string at runtime. You can also use the form's OrderBy as suggested by June7
(but will not modify the SQL string of the form's RecordSource).

 

[JamesJ]

I didn't think to look there. I was on the Data tab too and never saw it.
deleted that and set the 'Order By On Load' to no.
Although the 'Order By' text get put back when I re-sort it seems to be ok
now.

Thanks,
James