Filter on Load

[Jim Dudley]

I have tried several ways in the Design View of simple Form to get it to load Sorted in descending order on the Date Field.

I am looking in The Property Sheet for the [Date Field]. What do I enter here to get the Form to load and sort descending on the Date Field?

The Key Field in this table is ID.
Other fields are:

1. File Name
2. Import Date
3. Total Records

There are several other instances where I would like to apply this same concept. Any suggestions would be appreciated.


Thank you.


Jim

 

[RainLover]

If you are using Queries you can change the sort order there.

If you aren't then create a new query and paste your SQL in the SQL View. Adjust the sort order then view the SQL which you can copy and paste it back where you are using it.

If this fails then post a Copy of your SQL and someone will adjust it for you.

 

[gray]

Hi

I think you may be looking at the wrong property.

Right click your form and put it into design view....go to the property sheet and ensure 'form' is in the drop down box. Click the Data tab of the property sheet and you will see two properties

Order By
Order By On Load

Put your date field in the Order By.... "[Import Date] DESC"

Set Order By On Load to True (yes). Now save the form and I think that should do the trick next time you open it.

P.S. I assume here that your subject "Filter on Load" really meant "Sort on Load".

.

 

[Jim Dudley]

You were right about the Title. It should have said Sort. Anyway it works and I thank you.

Regards,
Jim