I need to enter data in a form and then run a query which uses some of the data I have entered , the result of which is stored in the form.
The logical process I think may be
1. Open form
2. Enter data
3. Click button on form passing this record's data to a parameter query
4. Save query result to this record via the form.
The first thing I need to work out is how to pass the data to the parameter query.
Thanks in advance