Sorting Reports

[harris]

I have a list box on a Form labeled "txtSortBy". How do I pass this
field to a Report to order the way I have chosen on the Form?

Currently, I have created 3 of the same reports and hard coded the
sorting within each Report. (What a drag to maintenance when I want to
make a design change and must update ALL three of these reports,
instead of just one)

[salad]

ha****@compu-type.net wrote:

I have a list box on a Form labeled "txtSortBy". How do I pass this
field to a Report to order the way I have chosen on the Form?

Currently, I have created 3 of the same reports and hard coded the
sorting within each Report. (What a drag to maintenance when I want to
make a design change and must update ALL three of these reports,
instead of just one)

In the OnOpen event you could do something like
Me.OrderBy = Forms!ReportCallingForm!txtSortBy
Me.OrderByOn = True

For the most part, reports are sorted on what you have specified as the
group level sorting. Look at GroupLevel Property in help and related
topics.