Hey All

I would lik to increase the flexibility of the reports in my access 2000 db. I have several reports which would be useful to sort by different fields. Is there anyway of changing the sql string at runtime, either from a form which opens a report, or from the report itself, in order to change the sort order on the form???


ive tried some vb code which tries sets the records source, however it doesnt seem to like it.

Thanks

Relg