Using CommandBarEdit in a popup

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi guys!

How can i do this:
I want to create a popup menu, when the user clicks the right mouse into a reportcontrol. in this report control i want to have a CommandBarEdit where the user can input his search string. by pressing enter the report control should filter by the user text.

why is this post in the commandbars-active-x?

I have already created a popup menu which contains textbox. how can i get the text the user want to search for?

i am using following code to build the Popup:

        Dim popup As CommandBar
        Dim Control As CommandBarControl

        Set popup = CommandBars.Add("Popup", xtpBarPopup)
        With popup.Controls
            .Add xtpControlButton, 1000, "Menu1"

            Set Control = .Add(xtpControlEdit, 1001, "Input Your Query: ")
        End With

        popup.ShowPopup

the get the value, i have tried as follows:

        Dim ac As CommandBarEdit
        Set ac = Me.CommandBars.FindControl(, 1001)    'This doesnt works?