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]

On Jul 25, 2:51*pm, Element <[e-mail]:

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]

>"Access" <al*********@gmail.comwrote in message

>news:5b306873-8df7-45f3-8a5a->55**********@y21g2000hsf.googlegroups.com...
On Jul 25, 2:51 pm, Element <[e-mail]:

>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