hiding form while displaying query

[BBC via AccessMonster.com]

I have a form where the user can select a simple query via a listbox. When
it runs the form remains on top of (covers) the query results. Is there a
way to hid the form until the query is close (via close "X" button). I found
the following posted by "Wade" that works for reports (requires acDialog mode)
, anything similar for queries ??
Me.Form.Visible = False
DoCmd.OpenReport "MyReport", acViewPreview, , , acDialog
Me.Form.Visible = True

If not how would this best be done or is there a better way altogether.
I guess I could create a form but I have many different very simple info
queries and don't want a separate form for each one. I don't need the
sophistication of a report

Thanks

 

[Allen Browne]

Open the form in design view, and set its Modal and Popup properties to No.

That should stop if floating on top of everything else.

 

[BBC via AccessMonster.com]

Modal was no an I changed popup to no and that worked. However the form is
now full window size (rather than the 7x6 I want) and I'm unable to control
it's size (even with DoCmd.MoveSize on form_load, which I always use anyway).
This is the opening/main form for my App. I'm using 2007.
any further thoughts?
thanks

Open the form in design view, and set its Modal and Popup properties to No.

That should stop if floating on top of everything else.

I have a form where the user can select a simple query via a listbox. When
it runs the form remains on top of (covers) the query results. Is there a

[quoted text clipped - 11 lines]

queries and don't want a separate form for each one. I don't need the
sophistication of a report

 

[Allen Browne]

Click the Office button (top left), then Access Options (bottom of dialog.)

In the options for the current database is the choice to work with tabbed
documents or child windows.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Modal was no an I changed popup to no and that worked. However the form
is
now full window size (rather than the 7x6 I want) and I'm unable to
control
it's size (even with DoCmd.MoveSize on form_load, which I always use
anyway).
This is the opening/main form for my App. I'm using 2007.
any further thoughts?
thanks

Open the form in design view, and set its Modal and Popup properties to
No.

That should stop if floating on top of everything else.

I have a form where the user can select a simple query via a listbox.
When
it runs the form remains on top of (covers) the query results. Is there
a

[quoted text clipped - 11 lines]

queries and don't want a separate form for each one. I don't need the
sophistication of a report

 

[BBC via AccessMonster.com]

I have Tabbed windows as the default (with "display document tabs" ticked).
The other option available is "overlapping Windows" (I'm using 2007 so it
seems"child" is not a choice).
thanks

Click the Office button (top left), then Access Options (bottom of dialog.)

In the options for the current database is the choice to work with tabbed
documents or child windows.

Modal was no an I changed popup to no and that worked. However the form
is

[quoted text clipped - 18 lines]

 

[Allen Browne]

I don't think I understand the issue.

If you use 'overlapping windows', the behavior is the same as it was in
previous versions, i.e. popup forms are opened independently of tha main
Access window, and non-popup forms are child windows in the main Access
window.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have Tabbed windows as the default (with "display document tabs" ticked).
The other option available is "overlapping Windows" (I'm using 2007 so it
seems"child" is not a choice).
thanks

Click the Office button (top left), then Access Options (bottom of
dialog.)

In the options for the current database is the choice to work with tabbed
documents or child windows.

Modal was no an I changed popup to no and that worked. However the form
is

[quoted text clipped - 18 lines]

queries and don't want a separate form for each one. I don't need the
sophistication of a report

 

[BBC via AccessMonster.com]

This is my main/opening form, all the child forms from it are "popups" (I
think all modal) and that all works OK. I think the reason I did not make it
a popup was because I present reports to the screen (via Preview mode) and
they would always end up behind this main screen. By making this screen non-
popup they opened on top of it. I'll have to recheck this, but I think it
was the case.

I don't think I understand the issue.

If you use 'overlapping windows', the behavior is the same as it was in
previous versions, i.e. popup forms are opened independently of tha main
Access window, and non-popup forms are child windows in the main Access
window.

I have Tabbed windows as the default (with "display document tabs" ticked).
The other option available is "overlapping Windows" (I'm using 2007 so it

[quoted text clipped - 12 lines]