Word Automation - Setting current record only 1

[wbwillson]

Hi,

I have a form which collects data which eventually gets sent to a Word document via bookmarks. I need to be able to send only the current record on my form to word. Currently if I have say 10 records in my table, when I generate the Word Doc it automatically goes to Record #1, but I'd like it to go directly to whatever record I happen to be on in my form.

I've tried setting the recordset like:

rstCust.RecordCount = [forms]![frmEmployees]![ID]

But this doesn't work. Any ideas would be greatly appreciated!

Bill

 

[wbwillson]

Answered my own question. Thanks anyway.

I used the following to pass just the form's current record to word using an On Click event.

Dim objWord As Word.Application

'Start Microsoft Word
Set objWord = createObject("Word.Application&quot

With objWord
'Make Word visible
.Visible = True

'Open the document
.Documents.Open ("C:\MyMerge.dot&quot

'Move to the bookmark and insert text from the form
.ActiveDocument.Bookmarks("First&quot.Select
.Selection.Text = (CStr(Forms!Employees!FirstName))

End With

Maybe someone else will find this useful.

Bill