Freeze Pane a Subform

[cheer]

Subform - Freeze Pane and Filter For Menu

1) How to freeze pane a subform ?

2) How to display the "Filter For" menu ? I can see the menu at design mode, when I have set the form under the Start Up, the menu cannot displayed.

 

[namliam]

No such thing exists in Access...
If you have a subform, the "form it self" (not the main form, but the subform itself) has a header. Anything in the header is "frozen"

 

[cheer]

No such thing exists in Access...
If you have a subform, the "form it self" (not the main form, but the subform itself) has a header. Anything in the header is "frozen"

Thanks for your answer, how about question 2?

 

[namliam]

Your second question was not there when I answered the first

Me.Filterby = "some filter"
Me.Filterbyon = true
or something like that in code will apply a filter.... If you just want the menu/toolbaar simply "pull it up" using View> Toolbar

If you want to do a "proper" searhc/filter etc... Have a search on the forum for "search form" in the references part of the forum. You should find some nice samples there...

 

[cheer]

I am looking for the built-in menu come in Ms Access 2000, I cannot detect any
a) Unfreeze pane - Already found.
b) Filter For - Check the attachment below
menu from the MS Access 2000. I have a subform which I prefer to use the built-in menu to control or filter data rather than hard code through VBA like Me.Filterby = "some filter"
Me.Filterbyon = true.

 

[boblarson]

You CAN freeze a pane in a subform (or form) displayed as a datasheet. You need to select the field first like:

Me.YourControlName.SetFocus
DoCmd.RunCommand acCmdFreezeColumn