I am taking my Access DB over to an ADP with SQL back end. The main switchboard I have set up runs multiple reports based on which check boxes the user selects and dates from and to. The dates are present in several reports / views so I am just wondering what is the best way to pass the dates from the form to the multiple views? From what I am seeing its a stored procedure but this is new territory for me.

My idea was to have a date table that emptied and repopulated on every new date selection but I realise this would be cave man way to do it and I am unsure I can even base the view date range on the table results.

I hope that all makes sense and someone can point me in the right direction. Thanks