I have a form which contains five sub-forms, each of which displays the results of some different queries. The forms take a while to display due to the complexity of the queries which are compound queries.
That's not a problem - I don't mind that wait. However I have a command button on the form to print it. Printing seems to take an age, and I can only assume that the queries are being recalculated. How do I get a form to print "just as it appears" without working running the underlying queries again?