If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Order By isn't working
I have a continious form associated with a table.
I've entered into the Order By form's property the name of the table's field (Table1.Field1) expecting that the data in the form would be sorted by this field but it's not working. Could anybody clarify it? Thanks |
#2
|
|||
|
|||
Hi Alex
What are you using as a recordset? If it's a table you should look at indexing the field you wish sorted, or if the recordset is a query then set the sort in the query. Hope this helps Maurice St-Cyr Micro Systems Consultants, Inc. I have a continious form associated with a table. I've entered into the Order By form's property the name of the table's field (Table1.Field1) expecting that the data in the form would be sorted by this field but it's not working. Could anybody clarify it? Thanks |
#3
|
|||
|
|||
On Thu, 19 Aug 2004 12:28:53 -0700, "Alex"
wrote: I have a continious form associated with a table. I've entered into the Order By form's property the name of the table's field (Table1.Field1) expecting that the data in the form would be sorted by this field but it's not working. Could anybody clarify it? Thanks You have to do it in code, probably when the form opens. Me.OrderBy = "Field1" Me.OrderByOn = True - Jim |
#4
|
|||
|
|||
Thanks a lot, Jim.
This approach is working. Regards, Alex -----Original Message----- On Thu, 19 Aug 2004 12:28:53 -0700, "Alex" wrote: I have a continious form associated with a table. I've entered into the Order By form's property the name of the table's field (Table1.Field1) expecting that the data in the form would be sorted by this field but it's not working. Could anybody clarify it? Thanks You have to do it in code, probably when the form opens. Me.OrderBy = "Field1" Me.OrderByOn = True - Jim . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Wrong sort order of report's details section | dsjohn_242 | Setting Up & Running Reports | 6 | July 12th, 2004 10:21 PM |
Ineffective change of plot order in series formula | Jon Peltier | Charts and Charting | 3 | May 30th, 2004 02:15 AM |
Sorting of mixed zip codes (5 digit and 9 digit) in ascending order | Jason Morin | Worksheet Functions | 2 | January 26th, 2004 09:08 PM |
Purchase order | Ross | Worksheet Functions | 1 | October 20th, 2003 11:30 AM |