Mail merge from access

[Jdubs]

I have designed a database such that when I click my 'create letter' button in the form it auto open word and mail merges the data from that record, I have a problem that sometimes the word macro opens another instance of access and therefore not selecting the record I was viewing in the form. Could anyone tell me a way round this please? Thanks Jdubs

 

[JoyInOK]

I'm guessing that you have your Word document's datasource set to a query. Set that query in code to the record you are currently viewing before calling the code to open Word.
Public Sub SetQuery(strQueryName As String, strSQL As String)
'set the query from which the merge document will pull its info
Dim qdfNewQueryDef As QueryDef
Set qdfNewQueryDef = CurrentDb.QueryDefs(strQueryName)
qdfNewQueryDef.Sql = strSQL
qdfNewQueryDef.Close
RefreshDatabaseWindow