cmd filtermenu issue

[chrisjames25]

Hi

You guys have previously helped me design a continuous form with a column headers. On each header is a cmd button i click to bring up the default filter menu using the following code:

DoCmd.GoToControl "Txt_Column1"
DoCmd.GoToRecord , "", acFirst
DoCmd.RunCommand acCmdFilterMenu

Works fine after a few tweaks. Anyhow i now wanted to replicate this continous form but for other data so i copied the form and renamed it. Changed the recordsource to a different saved query and amended all the control sources. Loaded form and it looks exactly how i want it with one exception.

i click on the command button of a column for the filter menu and it does a 2046 filterr menu not available at this time error.

Any ideas why a coptied form which was working in original would not work in copied form?

 

[theDBguy]

Hi. Hard to say without seeing it in action. Maybe retrace your steps and see if you may have missed something. Otherwise, maybe consider posting a demo copy of your db.