Hide pop-up whilst query results are displayed

[Mark]

Hi all,
I have a pop-up which has several command buttons which allow users to
run a few stored query's. Having the query's displayed as report is not an
option due to several reasons. My problem is that I want to hide the popup
whilst the results of the query are displayed. I can get the form to hide ok
with the On_Click event of each command button, it's un-hiding it that's my
problem.

Can anyone offer any help on this?

TIA

Mark

[MacDermott]

In such cases, I've put code behind the button which
opened the query
set the form's Visible property to False
looped, using SysCmd to determine the state of the query, until it
closed
set the form's Visible property to True.

HTH

"Mark" <ma**********@ntlworld.com> wrote in message
news:cO*************@newsfe5-win.ntli.net...

Hi all,
I have a pop-up which has several command buttons which allow users to
run a few stored query's. Having the query's displayed as report is not an
option due to several reasons. My problem is that I want to hide the popup
whilst the results of the query are displayed. I can get the form to hide ok with the On_Click event of each command button, it's un-hiding it that's my problem.

Can anyone offer any help on this?

TIA

Mark

[Mark]

After a little research, I found I could do this by creating a form based on
the query and open the form in datasheet view. As it is a form, I can use
the events of the form to do as I need!!!

Mark

"Mark" <ma**********@ntlworld.com> wrote in message
news:cO*************@newsfe5-win.ntli.net...

Hi all,
I have a pop-up which has several command buttons which allow users to
run a few stored query's. Having the query's displayed as report is not an
option due to several reasons. My problem is that I want to hide the popup
whilst the results of the query are displayed. I can get the form to hide
ok with the On_Click event of each command button, it's un-hiding it
that's my problem.

Can anyone offer any help on this?

TIA

Mark