"Jeff L" <jl*******@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
>I misinfomed you. The reference to the form cannot be used and I
thought that it could. You could run a make tbl query that creates
you record source for your mail merge. In that Make Tbl query you
could refer to the form to grab the person you need. Sorry about the
mixup.
Actually, I have a working example that automatically builds the merge based
on the current form.
This means that you can word-enable ANY form in your application with ONE
LINE of code, and the data source
for word will be setup for you auto-matic. This means my example solves 99%
of the merge issues that come up
when working with a application, and ANY form data can instantly be merged
to a word template with one line of
code (the default is to merge the CURRENT ONE record).
You can find this code example here:
http://www.members.shaw.ca/AlbertKal.../msaccess.html
The the above exmaple...it should solve both of your requests...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com