Displaying query from a form

  • Thread starter Thread starter rmcompute
  • Start date Start date
R

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?
 
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.
 
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.
 
Back
Top