I agree with Paul; just refer to the controls on the form.
However, I wanted to comment on the code.
"Primary" is a reserved word in Access and shouldn't be used as an object name.
Spaces in object names is a very bad idea. ("LRO Database")
And "Database" as part of a table name (or a query)???
Code:
Public Sub Command908_Click()
Dim wApp As Word.Application
Dim wDoc As Word.Document
Dim rs As DAO.Recordset
Dim sSQL As String
Set wApp = New Word.Application
Set wDoc = wApp.Documents.Open("N:\Dropbox\Dropbox\BCNU\Labou r Relations\Templates\step3presentation-Access.docx")
sSQL = "SELECT GFirstName, GLastName, GPhone, Issue, Primary, SLastName, SFirstName, SPhone" '<< "Primary" is a reserved word
sSQL = sSQL & " FROM [LRO Database]"
sSQL = sSQL & " WHERE ID = " & Me.ID ' "Me.ID" refers to a control on the form
Set rs = CurrentDb.OpenRecordset(sSQL)
wDoc.Bookmarks("GFirstName").Range.Text = Nz(rs!GFirstName, "")
wDoc.Bookmarks("GLastName").Range.Text = Nz(rs!GLastName, "")
wDoc.Bookmarks("GPhone").Range.Text = Nz(rs!GHomePhone, "")
wDoc.Bookmarks("Issue").Range.Text = Nz(rs!Issue, "")
wDoc.Bookmarks("Primary").Range.Text = Nz(rs!Keyword, "")
wDoc.Bookmarks("SLastName").Range.Text = Nz(rs!SLastName, "")
wDoc.Bookmarks("SFirstName").Range.Text = Nz(rs!SFirstName, "")
wDoc.Bookmarks("SPhone").Range.Text = Nz(rs!SPhone, "")
wDoc.SaveAs2 "N:\Dropbox\Dropbox\BCNU\Labour Relations\Individual Grievances" & rs!GFirstName & rs!GLastName & "_Step3Prep.docx"
wDoc.Close False
wApp.Quit
'clean up & exit
rs.Close
Set rs = Nothing
Set wDoc = Nothing
Set wApp = Nothing
End Sub