Sort Datasheet which is a Sub-Form

[jcmv007]

Using Windows XP SP1 and ACCESS SP1.

I would like to sort the records shown in a datasheet form (fsfrDetails) by any column selected by the user.

It sounds easy but here is were it gets complicated (at least form me),
1. It is a subforms in the form called frmUnits
2. In fsfrDetails for the double click event of all the fields shown there is code to open another form.
3. I need to hide the command bars.
4. I would like to sort ascendig or desending.

I have create my own commandbar using command buttons.

 

[hneal98]

Just have the user right click on the column they want to sort and choose sort Acending order.

 

[Nowell]

Hi,

Or just go to properties and hit the data tab and enter the order by clause there.

Nowell

 

[jcmv007]

Thanks Guys,

It works great.

 

[adamroof]

anything special for the ORDER BY Clause in the Data tab of the properites??

I tried HistDate DESC and it doesnt work.
Do i have to do Me.HistDate DESC or something, ive tried a bunch of ways.