This is the code I have put together so far. I'm trying to create a custom right click menu. I want to add the "Text Filters" dropdown to this menu and am looking for a little help. If you were viewing a datasheet and using the default shortcut menus you would see the "Text Filters" option in you right clicked. I'm looking to add that to my menu. Any help at all would be GREATLY appreciated!! I'm using access 2010. Thanks!
Dim cmbRightClick As Office.CommandBar
' Create the shortcut menu.
Set cmbRightClick = CommandBars.Add("cmdWIP", msoBarPopup, False, True)
.Controls.Add msoControlButton, 19, , , True 'Copy
This code works fine. I'm trying to add to this shortcut menu the option "Text Filters". This is a combobox that provides the user the ability to choose several options like "Equals", "Does Not Equal", "Begins With" etc. I don't know the button IDs and am not sure how to go about adding a combobox to this menu.
Okay, maybe I can sneak up on this instead since it looks like there are no answers. Can someone tell me what that "Text Filters" is on that shortcut menu? Is it a dropdown? A ComboBox? If it is one of these how would I go about incorporating it into my menu above? Any help at all would be appreciated! Thanks!