descending continuous form

[anasazii]

Hello everyone.

I have a main form that consists of tabs. On one of the tabs, I have a subform that is made of continuous forms. The idea is to have a call history, and to document everything when calls come in. When an entry is made, it is automatically set to that day's date.

Right now, the records are in ascending order with a blank, new record at the beginning of the forms to enter new data.

I would like to be able to have the records in descending order by date with the blank record still being at the top of the form. Does anyone know how to accomplish this?

I have tried changing the "Order by" Property to "call_history.contact_date desc", but it places the blank record at the end of all the forms, and hence out of order.

Any Ideas??

 

[WildHare]

Right now, the records are in ascending order with a blank, new record at the beginning of the forms to enter new data.

Are you saying the blank "new record" line is at the TOP of the continuous form? The only way that can happen is if the record is SAVED with just the key field in it, and then the form is requeried - the new record will appear at the 'top' of the list, but there will be blanks for all the non-key fields. IF you sort the query that produces your recordset for the continuous form in DESCENDING order by the DATE ENTERED, it will do this for you.


Remember, you're unique - just like everyone else
You're invited to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com