Queries

Hi Fiona

Thank you for your question

First create your query, with all the fields required.

Then create a form and set its data source equal to the query that you have created. When you open the form the query will first run and feed its data into the form. You will see only the form with the query's data, and not the query itself.

If you are running a parameter query, opening the form will first run the query and as a result the dialog boxes prompting for parameter values will run, and when parameters are entered the form will open

Hope this is help full

Regards

Stephen