Displaying query results in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a WorksOrder form setup. I also have several queries setup to filter
for completed works orders, incomplete works orders, works orders that have
missed deadlines etc. How can I get the form to show the results of these
queries?

I can do it with reports but I need to be able to edit the data once it has
been filtered. Hence the need to use forms.

Thanks

Dave
 
You can use the query as the recordsource for the form. If your query is
updatable when you look at it from the query view, it will also be updatable
when you look at it as a form.

Linda
 
Except, I would like to use the same form to display various different
queries. I'd rather not use a different copy of each form for displaying the
results of each query. Eventually I'd like to use two combo-boxes to select
the query criteria (or one combo-box to select each pre-constructed query)
then have the form display the relevent records, which can be selected
through the navigation buttons.

Thanks

Dave
 
use subforms for the filtered queries.


David M C said:
Except, I would like to use the same form to display various different
queries. I'd rather not use a different copy of each form for displaying the
results of each query. Eventually I'd like to use two combo-boxes to select
the query criteria (or one combo-box to select each pre-constructed query)
then have the form display the relevent records, which can be selected
through the navigation buttons.

Thanks

Dave
Click to expand...
 
Back
Top