Subform rows show up "Descenting" order all the time...

[acnovice]

Hi,

The report form was created with subform. However, subform shows up "Descending" order. It's ok in main form because it is set to "Ascending" order.

How do I change the display order of subform to "Ascending" ?

 

[HitechUser]

acnovice,

I assume you are using a datasheet view?? If so then select any field and right mouse click. You can change the sorting order from there.

If not... Then need more info....


[

 

[dhookom]

You should use a subreport where you can set the sorting and grouping.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[HitechUser]

Boy do I feel stupid, sorry I did not correcly read your post. I did not see "report"... I thought is was just a subform..

 

[acnovice]

Hi Guys,

Thank you for the answers... I used "subreport" for that and it works perfect.

Have a good weekend.