I don't do much programming, and I've run into a problem. What I would like to do is have the user open a form, entering/choosing information, then clicking on a command button to merge the record into a Word mail merge template. Ideally, I would like this to be done all in one button. I've tried the "Merge Single Word" code, however, in order for the code to work for me, the record source for the form has to be set to the table/query that will be the record source for the mail merge template. When I set the form's record source to the query that needs the information entered on the form, the form fails. When I set the form's record source to a table generated from the query that needs the information on the form, I get an error message that the record or database is locked. I'm so frustrated because I am so unfamiliar with visual basic. I have searched through the community groups and newsgroups, but haven't found exactly the code I need. When I do find some code, it's always missing something that I can't figure out. If anyone could help me I would appreciate it. I will be happy to provide any additional information. Thanks!