Print list box contents.......

[ablim]

...seems such a simple thing to do but I'm completly stuck. Everything I've found on the forum suggests alternatives to doing to above i.e. setting the query that produces the list to produce that report print directly but that wont work for this situation unfortunately.

Some background....
I have a form (lucky me) in which the user enters 3 category levels and a branch id, they click a button to generate a list of 50 random stock ids so they can be checked at the branch. A preview of the Stockid's (along with description and Stocklevels) is shown in a list on the form. The stock manager then needs to print the list box contents. If the query is re-run it will differ from what is shown in the list so I need to avoid this.

Any help greatly appreciated.....

 

[Michael J Ross]

Does the list have to appear on the form?, you could get the list to go directly to a report that opens up in preview when you click the button by attaching the report to the button.

 

[ablim]

Yes I'm affraid it does cos there will be some further development at some point to delete indvidual records before printing the list, tho that is a good idea for a temporary measure