Question Help with order by recent date

[josephbupe]

Hi,

I have a list of items in the continuous form. The last column holds date stamp to indicate when a record was modified. What I want is to ensure the recently modified record stays on top of the list of items.

How can I do this for vb code/query?

Joseph

 

[DCrake]

Sort you recordsource by the modified date descending, so that the newest is first.

 

[josephbupe]

Hi,

I have a list of items in the continuous form. The last column holds date stamp to indicate when a record was modified. What I want is to ensure the recently modified record stays on top of the list of items.

How can I do this for vb code/query?

Joseph

Hi DCrake,

I have attached a piece of what am working on for your scrutiny and advise.

In this case, the main form is Frm_Files_Edit. Double-click the first or second record and Frm_FileCases opens in which there is a subform with the DateChange field which I want sorted by recent date whenever any record is changed in the po-up form (Frm_Progress).

The thing is that I already have other query acting as a record source of the form Frm_FileCases and am afraid that including a sort by on DateChange textbox will return no records where no change has occurred.

The database will be used to record cases and track process, status as well as current location of each case within the command line of my organisation.

Joseph