Re: Reverse Order
Date: Fri, 3 Dec 2004 14:25:37 +0200
Do you mean display the most recent dated records first? If yes:
If the form's recordsource is a query, then open the query in design view
and set the sorting on the date field to descending;
If the form's recordsource is directly the table, then open the form
indesign view, select the form object, display properties, and on the Data
tab set the Order By property to:
"James" <James@discussions.microsoft.com> wrote in message
> How do you make a form display in reverse order by using the date field
- How can I make a form re-read (refresh) its datasource
... seems to work except when I open the display form to display the data ... the display form with this new query as the recordsource. ... So, when I execute, if the form F2 is not open, the form opens and ...
- Re: "Reading" user input
... Have the recordsource of the form as a ... In the Criteria of the relevant fields in the query, ... Joe wrote: ... > display a set of records from a table. ...
- Re: LIST BOX ISSUES
... Easiest approach is to have the recordsource of your list box contain all of ... base the list box on a query, say, that returns the ... even if you only display one field in the list box. ... > automatically in other boxes on the form. ...
- Re: "Object doesnt support this property or method"
... INNER JOIN ... Note that the query has been in production for a couple of ... that I also tried) display as expected. ... verified that "Title" is indeed defined by the form's RecordSource ...
- Re: DB Result Wizard Error
... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...