Printing jus the list box

ChampionDuy

Registered User.
Local time
Today, 15:58
Joined
Mar 14, 2002
Messages
94
I have a list box that displays the results of a SQL query that a user enters into a text box. I would like to print this list box but I cant figure out how to get it to print only the list box and not the whole form. Is there a way to just print the list box values and not the whole form? The list box name is lboResults and I cant figure out how to print it using the docmd.printout or just the .print commands. Any help would be greatly appreciated.
 
You should be able to use the OutputTo Method to print the query directly:

DoCmd.OutputTo acOutputQuery, "queryname", ....

Read the help entry to figure out what you want for the rest of the arguments.
 

Users who are viewing this thread

Back
Top Bottom