URGENT

[Alicia]

My database is due to be finished tomorrow...
However, one small problem, I want my records to show in backwards order, so the most recent one is shown on the form first.
My primary key is Call No and when the program is opened I want it to show Call No 500 say, and scrolling through the records will show 499, 498..... 1.
PLEASE HELP! It used to do this but I have managed to do something to change it!

 

[Cheryl Fischer]

Make the Record Source of your form a query and sort it in descending order
by Call No; for example,

Select * from MyTable ORDER BY [Call No] DESC

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

My database is due to be finished tomorrow...
However, one small problem, I want my records to show in backwards order,

so the most recent one is shown on the form first.

My primary key is Call No and when the program is opened I want it to show

Call No 500 say, and scrolling through the records will show 499, 498.....
1.

PLEASE HELP! It used to do this but I have managed to do something to

change it!