Perhaps, not "quite" as I had envisioned but, for other "novices" out there:
Though the ultimate presentation changed (no subform) I put an additional field, "CF" (Conversion Factor) in the table holding numeric values and, within the original query used to generate my original form, added both it and as many calculated fields necessary to convert all numeric values (later to become visible within their own "Expression" text field) based on that inputted in "CF".
Then, instead of generating the form from within the forms design section, I saved the saved, "still open" query, as a "form". The resultant form is then a continuous list with each individual record available. NOTE: The calculated "Expression" fields are only visible from within the form and are not stored, only the "Conversion Factor" is!
That may not seem too important, however, if using the data to produce charts, it means that the charts are produced using only individual records as their source and not the "sum" of all records within the group! As you then advance through your records the chart displays values for each.
I hope this is of use?
Should an "Expert" take pity, assistance would be appreciated here:
I will be using varying versions of the same form, some with both fixed and user-defined parameters. This means that, where charts are used, the user-defined parameters have to be re-inserted once a form loads before the chart will.
Question: Can I (and if yes, how do I) use a macro to insert the relevant text from the form into the custom-dialog box/s and therefore remove the needless duplication of effort?
Thanking you in advance
__________________
Pete
www.celna.co.uk
Nothing ever changes - Still stuck in the same damned corner!
|