Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA script causes recursive opening of database

Status
Not open for further replies.

denno

IS-IT--Management
Aug 13, 2001
3
AU
I have written an event procedure in a form which opens a word document that will attempt to Mail Merge data from a query in the database that is already open. The problem is that the word document opens a second copy of the database rather than using the database that is already open. Could any one advise me how to prevent the Word from opening the second copy of the data base and use the query in the database file that is already open.

thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top