One set of criteria, Multiple Forms

[matthewnsarah07]

I'm sure this one has been asked time and time again!

I currently have a set of staff questionairres each on a different table.
Currently when I want to export all the scores for one employee to excel (eventually) I have a macro which runs 7 queries, but each asks for the same criteria (Date To & From) and (Staff Name) in turn - very time consuming!

How do I create a query or macro which will ask once for a date range and an employee name and apply to all of my queries?

I am a novice on access and am trying to do this without SQL

Thanks for your help

 

[pbaldy]

Have the user input the criteria into form controls and have your queries all look to the form controls. Instead of this in the query

[Enter date]

you'll have this

Forms!FormName.ControlName