I have a subform on a tab control.

[jgarnick]

I have a subform on a tab control. The subform has 6 or 7 fields. I'd like to be able to have the user click on the column heading bar in the subform and have the data sorted by that column. It's the equivalent of having the user highlight the column and then press the A-Z or Z-A icon in the toolbar. Can this be done??

Thanks!

jgarnick
jgarnick@aol.com

 

[THoey]

Just a WAG here JG, but could you create an invisible but active button for each of the columns and place it over each of the column bar headings. Then set them to requery based on that sort order? I know I have seen that used somewhere like that before...

Hope that helps...

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?

 

[jgarnick]

Thanks Terry, I'll try that--I'm basically just trying to do what you can do in the database window when you click on the name or date modified (etc) bar. I'll give it a whirl--

jgarnick
jgarnick@aol.com

 

[raskew]

The commands, which you could place in the field's OnClick and OnDoubleClick events, are:

docmd.RunCommand acCmdSortDescending

and

docmd.RunCommand acCmdSortAscending