sorting in a datasheet subform

[rene1000]

I have created a form which contains a datasheet subform with multiple columns. On the form are two buttons which should sort ascending or descending based on the column selected in the datasheet. Does anyone know how to do this ?

Thanks allready,
Rene

 

[quest4]

Rene, just create two queries, one Acending and one decending. Then in the ONClick event of the command buttons add a DoCmd.Openquery "Query1 or Query2". If that don't work use a macro and use DoCmd.RunMacro. that should take care of it for you.

 

[rene1000]

Thats not really what i mean. I do not want to create two separate forms, each bound to another query.