Pop Up form blocking query results....

[Channah]

How do I make a Pop Up form loose focus so that I can display query results from a Cmd button? Should I just create a form for each query and make them pop up as well? I think that is the route I am going to take unless someone has a better idea.

Thanks
Chris

 

[WildHare]

The only way to make a pop up form lose focus is to close or hide it.

If you want to display your query resultset in a datasheet window, you'll need to remember that the datasheet is not very 'smart' - you won't be able to trap a close of it.

I'd probably suggest developing a continuous-mode form for each query, and use them. When you open the form,the query will run and populate it automatically. Then you can trap the close of the form and reopen or re-make-visible your pop-up guy.

Jim

If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[Channah]

Thanks... that is the solution that I was thinking would work best.

Cheers.