[b][red]This message was edited by Jademonkey2k at 2005-1-20 9:56:53[/red][/b][hr]
jus waqndering if anyone can help, iv made a form in Access and i am able to navigate records via it, easy right lol? well im trying to make a button that when clicked takes the current record and merges it with a ready made mail merge Word document, iv managed to comple this and make it work to a certain extent its just it doesnt merge the one record, it merges them all? i only want it to merge the current record, i dont know if anyone can help me with this? i'll put the code im using in a VBA module below, if anyone can tell me what im doing wrong or has a solution i would be greatful.
Dim ObjWord As Word.Document
Set ObjWord = GetObject("C:Documents and SettingsAdministratorDesktopDatabase ProjectMaster Thank You Letter.doc", "Word.Document")
ObjWord.Application.Visible = True
Name:="C:Documents and SettingsAdministratorDesktopDatabase ProjectDatabase 1.mdb", _
LinkToSource:=True, Connection:="TABLE Main_Contracts_Database", _
SQLStatement:="SELECT * FROM [Main_Contracts_Database]"