Entry level questions - Queries and Reports

[FootballGuy]

I have setup a query which is used as a basis for a report. I can then limit the records showing in the report by adding conditions in the query, which is fine.

My dilema is how can I do this when everything is run from a custom Switchboard. When you build the Switchboard the opportunity to add Forms and Reports are there, but not Queries. So, unless I give the users access to all of Access, which I don't want to do, then how do I allow them to limit what shows up in a Report? Is this somehow related to Parameters? Some advice of how to do this, or a starting framework, would be much appreciated.

Thanks in advance

 

[dcx693]

What I do is allow users access to forms where they can search for records, and then give them a command button where they can print the selected records.

The form doing the record search will need to employ either a parameter query (that will also serve as the recordsource for the report) or create a SQL query on the fly (and then open the report using code like: DoCmd.OpenReport "MyReport", , Me.RecordSource).