Dlookup on mail merge

[Tony Williams]

I have a mail merge letter that is linked to an Access database table. I can
map most fields that I need but some of the fields I want would be DLookup
fields if I was creating an Access report. How do I do DLookup formulas in a
Word document?
Thanks
Tony

 

[Tony Williams]

having Googled my question I've come up with this but it doesn't work I get
#Error

=DLookUp("[txtmemnumber]","[tblindividual]","[txtsurname]=Forms!frmMain!Subform1!frmLevymembersubform![cmbname.Column(1)]
&
[txtfirstname]=Forms!frmMain!Subform1!frmLevymembersubform![cmbname.Column(2)]")

 

[Tony Williams]

Sorry this was the wrong post it was meant for another Group! I still have
the problem!
Thanks
Tony

having Googled my question I've come up with this but it doesn't work I get
#Error

=DLookUp("[txtmemnumber]","[tblindividual]","[txtsurname]=Forms!frmMain!Subform1!frmLevymembersubform![cmbname.Column(1)]
&
[txtfirstname]=Forms!frmMain!Subform1!frmLevymembersubform![cmbname.Column(2)]")

I have a mail merge letter that is linked to an Access database table. I can
map most fields that I need but some of the fields I want would be DLookup
fields if I was creating an Access report. How do I do DLookup formulas in a
Word document?
Thanks
Tony

 

[Doug Robbins - Word MVP]

Use a query in Access as the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP