Filtering Word Footnotes in access

[Chris]

Hi Group,

From access I am generating standard letters (word documents). When the
letter is opened I would like to alter the footer depending on a specific
value in the database.

IF Value = a Then
document.footnote = "Some Text"
Else
document.footnote = "Hello World"
End If


I was trying to use various code including

a) intFootnotes = ActiveDocument.Footnotes.Count
b) ActiveDocument.Footnotes
c) myFootNote.Reference.Select

However I have not been able to get any of these to work.

Thanks for your time
Chris