I have a SQL View that runs and due to its complexity, it takes longer to lookup and load all the data into a table.  To add to that, there is an alternate version of that View that also runs at the same time but populates a separate table.

Currently, a user selects which table content they want to view with a radio button.  But we still wait for BOTH tables to load.  

Is there a way to only execute (1) lookup when a user selects, lets say a radio button option?

For example:  There is a need to populate a form using a view, with every employee who will be retiring in 1 year.  Then there is a very similar View to lookup every employee who will be retiring in 2 years.

It would be nice if my lookups could be dynamic in the sense of altering the 1 year value vs 2, but I think that is beyond the ability of me and Forms.

So, is it possible to only execute (1) lookup based on the user selection?

Or would the use of Stored Procedures be a better option for the situation?

Thank you for any insights.