Using the same form for multiple query results.

[Homegrownandy]

I have a form where the user can enter different data and use it to find what they are looking for.

They can search with a date parameter, a wildcard search by name, or even a list of everything under a specific project.

The question is; can all of the results use the same form?

To make the forms for my query results I've only ever used the form wizard.

All the queries are pulling the same data fields, just different records depending on user input.

So all of the forms look exactly the same, and any amendments need to be done on multiple forms.



I've used the same forms to view/add/edit before, by setting the condition on the button. I was hoping there would be a similar easy solution to this.

Andy.

[ranman256]

yes , all the queries can use the same form, but if you use a different form, you must make a different query for each form you use (not cool),
so its best to use the 1 form so all the queries look at 1 thing.

[Homegrownandy]

well I have different queries that produce the same end result regarding what data is displayed. They all show "site name" and "scheduled start".

The difference is how that information is obtained. One query will look at 2 dates set by the user and display anything in-between them. Another query will look from today and to today+14 (two week look ahead). And the third query will be a name search query.

I'm thinking they need to be three separate queries. correct me if I'm wrong.

BUT I think you misunderstanding the question. All of the inputs for those queries are indeed on one form (Scheduling menu).

Its the output I'm questioning. The output will always look the same but with different results brought back. And right now they open three different forms.

[orange]

Andy,

Study this Allen Browne Search article for ideas.

[Homegrownandy]

Thank you orange, I might come back to this at a later date, seems like it will take some time to implement. I've bookmarked it. Cheers again.