Hello,
I have a form with a combo box that allows you to select an account and a button that takes you to a form that displays the information i want to merge.
The query for the form with the information diplayed has[forms]![frmletterintro][LetterAccount] in the criteria of the account field.
I have the word document set up with the fields of that query.
when i select the query (qryletterintro) and go to Tools-Office Links-Merge it with MS Word and go through the wizard i get an error:
"The data source of the document you selected is different from the source you selected when starting the Mail Merge Wizard .Would you like to change the source?"
To which I answer Yes, only to get a Enter parameter box with [forms]![frmletterIntro].[letterAccount]
"Letteraccount" is the name of the combo box on the first form with the drop down of accounts (frmLetterIntro)
frmLetterIntro2 is the name of the form that comes up with all the information from the query.
Any Comments,suggestions or thoughts would be very helpful.
Thankyou for your time
Regards,
Anna
I have a form with a combo box that allows you to select an account and a button that takes you to a form that displays the information i want to merge.
The query for the form with the information diplayed has[forms]![frmletterintro][LetterAccount] in the criteria of the account field.
I have the word document set up with the fields of that query.
when i select the query (qryletterintro) and go to Tools-Office Links-Merge it with MS Word and go through the wizard i get an error:
"The data source of the document you selected is different from the source you selected when starting the Mail Merge Wizard .Would you like to change the source?"
To which I answer Yes, only to get a Enter parameter box with [forms]![frmletterIntro].[letterAccount]
"Letteraccount" is the name of the combo box on the first form with the drop down of accounts (frmLetterIntro)
frmLetterIntro2 is the name of the form that comes up with all the information from the query.
Any Comments,suggestions or thoughts would be very helpful.
Thankyou for your time
Regards,
Anna