Problem ordering records on a report

[badulake1]

Hi there,

I have (on Access97) a form that has a list that can be reordered on runtime. On the same form I have a button to print the Rowsource of this list item. However, even though the list is ordered, the report always prints in the same order. This is how I open the report:

DoCmd.OpenReport stDocName, acPreview, List.RowSource

The problem is, as I said, the report doesn't show ordered. I tried something else which was to set through vba (after the OpenReport) the OrderBy and OrderByOn properties but nothing happens (guess I should have to refresh the report since it has already been opened). Can anyone help?. Thanks in advance,

Javier

 

[princeshri]

order the data in a query and use that query in the report instead of opening a table directly.

HTH,

Shri

 

[badulake1]

But List.Rowsource is a query (when messageboxed it reads "select A, B FROM C WHERE D=E ORDER BY A), so I assume I am using a query in the report, not a table (the list is ordered and filtered, however the report is filtered but not ordered). Strange...

 

[princeshri]

what is the report datasource ?

 

[badulake1]

A list called List.Rowsource.

 

[badulake1]

A list (List.Rowsource).

 

[princeshri]

try setting it manually to the value of List.RowSource.