Creating a View or Save Function within a Form

[Coach Ty]

Can anyone tell me if it's possible to create a control or function, within a form, that allows you to view a query result and then subsequently save the query result?
What I would like for the form to do is the following:
Information is input into the designated fields.
Then with a control: Run the query and view the results
Then with a second control: Save the query results in a designated table
I'm just wondering if it's even possible to do this using access?

I would like the form to have two function options:
A "View Results" option to click on, and a "Save Results" option to click and save.

Please let me know if this is possible and if so, how to design the form.

Thanks for your help!

 

[Coach Ty]

Hello,
Thanks for your response!
First of all yes, the information that is initially input into the system, is relied upon for the queries.
I've already designed the queries that will be ran to produce the desired results.
The information is input and the queries produce the results.
I'll produce a make table query, that includes all of the sub queries to produce a table, where the results will be stored / saved on an ongoing bases. Then peridically I will be running an append query to insert updated results for each date, into the table.
What I would like to do is enter the information into specific fields in a form, lets say fields A, B and C. Click on a "view" key (if possible) that will run the queries, and then have the results subsequently appear in blank fields, lets say D and E, on the same form.
Once this is acheived, I would like to have the ability to click a "Save" key that will run the append query (if possible) to save the results in the designated table.
Are these possible to do with access or do I need another type of program?
i'm not sure how to go about creating a "subform" or how that would work.
Could you please explain? Sorry, but I'm new to access.
Thanks for your help, it's greatly appreciated!

 

[Coach Ty]

Thanks a lot I'll take a look at it.