This is known problem
(it happens when you change the name of your database). A description and
fix is mentioned he
http://www.mvps.org/access/bugs/bugs0011.htm
On the other hand, you might try my sample "super easy word" merge. Not only
does my example avoid your
problem, but also allows you to easily merge just ONE record.
You can give the sample a download he
http://www.attcanada.net/~kallal.msn.../msaccess.html
If it does what you want..then you can read the instructions on how to use
the neat code in your application.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
http://www.attcanada.net/~kallal.msn