Quote:
Originally Posted by ljungers
Hi and I hope that someone may have an answer for this, or an example of what I need to do. I have a Access database that a clerk will be entering a Order Number or Client Name or a Client City in a query screen, and the results should be shown on a screen that allows the the clerk to select one or more of the results shown.
The selected items then should be used to call Word and perform a mail merge using a saved word template to print a form letter using the information in the data base for each of the selected query results.
Thanks in advance from a Access newbie
I can't help with the mail merge in word. However, the search form will need to have a multi-select listbox that will be requeried based on the value entered an unbound text field and a combo box to allow the user to select Order Number, Client Name or Client City as the criteria field for the query. The query would then be built in vba before setting it as the Row source of the list box.
Mary
