standard toolbar sort buttons don't work for subform

[Element]

I have a master form with a simple subform that displays line items in
datasheet mode. Everything works fine, except that when the subform
has the focus, the standard Access sorting and filtering toolbar
buttons are not available. I also tried a custom toolbar, but they are
disabled there too.

It seems odd, because when the same records are diplayed on their own
"master" form in datasheet mode, those same toolbar buttons are
available. It seems incredibly silly that such built-in functionality
would work with a main form but not a subform. Any ideas for a fix or
workaround would be greatly appreciated.


Mark H.

[Access]

Re: standard toolbar sort buttons don't work for subform

On Jul 25, 2:51 pm, Element <mham...@lotusc reek.comwrote:

I have a master form with a simple subform that displays line items in
datasheet mode. Everything works fine, except that when the subform
has the focus, the standard Access sorting and filtering toolbar
buttons are not available. I also tried a custom toolbar, but they are
disabled there too.
>
It seems odd, because when the same records are diplayed on their own
"master" form in datasheet mode, those same toolbar buttons are
available. It seems incredibly silly that such built-in functionality
would work with a main form but not a subform. Any ideas for a fix or
workaround would be greatly appreciated.
>
Mark H.

Can't you just right click and sort?

[Fred Zuckerman]

Re: standard toolbar sort buttons don't work for subform

>"Access" <alderran666@gm ail.comwrote in message

>news:5b30687 3-8df7-45f3-8a5a->55c560f57572@y 21g2000hsf.goog legroups.com...
>On Jul 25, 2:51 pm, Element <mham...@lotusc reek.comwrote:

>I have a master form with a simple subform that displays line items in
>datasheet mode. Everything works fine, except that when the subform
>has the focus, the standard Access sorting and filtering toolbar
>buttons are not available. I also tried a custom toolbar, but they are
>disabled there too.
>>
>It seems odd, because when the same records are diplayed on their own
>"master" form in datasheet mode, those same toolbar buttons are
>available. It seems incredibly silly that such built-in functionality
>would work with a main form but not a subform. Any ideas for a fix or
>workaround would be greatly appreciated.
>>
>Mark H.

>
>Can't you just right click and sort?

It's not enough that the subform has focus, a field or column in the subform
must also have focus. You should also check for any code behind the subform
(like the On_Current event that might re-sort, requery, or reset the
recordsource).
Fred Zuckerman