Displaying query from a form

[rmcompute]

A form was created for the user to select fields to display, filter, and
sort. A query is then generated but it remains in the background and the
form must be closed to click on it. Is there a way to open the query in the
foreground and when the user closes it, control returns to the form?

 

[Duane Hookom]

You might want to create an unbound form with a subform control that has a
source object of
Query:NameOfYourQuery
You can open the main form in acDialog mode so that it will appear on top of
other forms.

 

[rmcompute]

Thanks for the response. The problem is that the query will change depending
on what the user selects on the form i.e., display, filter, and sort fields.
Is there a way the user can make changes to the form and run the query in the
foreground ? Currently the user makes his selections, clicks the submit
button and the query is created and run. However it runs in the background
where the user cannot see it except by closing the form. The idea was to
create a process by which the user can continue to refine his selection until
the proper data was selected without closing the query. Do you know if this
can be done?

Thanks again.

 

[Duane Hookom]

The solution I suggested is available in a demo "dynamsubfrm" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

This opens with a main form with criteria input and a subform that displays
the dynamic query.

 

[rmcompute]

Thank you. I will check the website

The solution I suggested is available in a demo "dynamsubfrm" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

This opens with a main form with criteria input and a subform that displays
the dynamic query.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm