heres a tricky one...

i have a form that displays and prints a graph of machine downtime.
it has (among other things) 2 option groups, one to select the downtime reason grouping (1 reason, all reasons, planned, unplanned) and the other to select the date grouping (day,week,month).
one combo box allows machine selection (must be selected) and also generates a wee list on the form to one side of the biggest reasons for the last 6 months to guide drilling down to one reason on the change event of that combo box.
the second combo is only visible when "one reason" is selected in the appropriate option group and allows the user to select - you guessed it - one reason.
and of course a start and finish date control boxes.
If the graph object on the form is clicked once, the queries run and the graph is updated. there is also a button (visible screen only) that then prints the form.
i have used a form so the graph can be seen and updated without flicking back and forth between a form and a report.

heres the rub
many different people want different machines, dates, periods, reasons etc etc which is good and means that they are using the info which gives us all a warm feeling, but currently i am the only user (network this and our network will bog down wayyyyyyyyyy too much!). the users of the reports need set graphs at set times, so what i want to do is somehow save the criteria and print out this form for each set of criteria automatically.

am i correct in creating a table (ive started to play with this) and then write some code to blah.value = xyz, blah.value = 123 then refresh/requery,print form for each record in the table?

or is there a better way????

cheers
mike c
i think that if it was just a report it would be easier, but i want to do it with the form i have now