accmdfiltermenu error

[chrisjames25]

Hi

I have a form with a subform within it. The subform is a continuous form. I wanted to add some of the standard filter options you get on a datasheet so did some digging and the internet suggests adding code to the label header and use on click event for label and insert following code:

Private Sub Lbl_Tier1Status_Click()
DoCmd.GoToControl "category"
DoCmd.RunCommand acCmdFilterMenu
End Sub

Whenever i do this i get the following error:
Runtime error 2046. The filtermen isnt available now.

Im using access 2016. Is this a feature that has been removed or am i doing something wrong.

Any help greatly appreciated.

 

[June7]

I just tested this and it works for me. I am using 2010 but I doubt has been removed in 2016.

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[chrisjames25]

FInally figured out the issue and it was as basic as could be.

WIthin properties i had allow filters turned to no.

Stupid me.