Close a dialog form after the resulting query is generated and open

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tim Mullin
    New Member
    • Aug 2010
    • 48

    Close a dialog form after the resulting query is generated and open

    Hello all,

    I have a problem that probably has a simple solution but I just can't seem to figure it out.

    I have a form (QueryScreen)th at has a button that opens another form (StateSearch) in dialog mode. On the dialog form there is a list box with a list of states and a button that runs a query to return customers that are located in the selected state.

    After running the query, the query appears immediately in a new tab - but the dialog box is still open and hovering over the results.

    When I add a line of macro to the query button OnClick to close the form the query is run and opens in a new tab but the current window shown is the original QueryScreen form and not the query results. In which case the user has to manual click to view the new tab with the query results.

    Is there any way to have the dialog form close but still have the query results appear without manually clicking over tabs?

    Any help would be greatly appreciated - thanks!
  • gnawoncents
    New Member
    • May 2010
    • 214

    #2
    I don't work with tabs much, but have you tried setting the original form to .visible = false when opening the second tab, then back to true in the on close event of the second tab?

    Comment

    Working...