Problem solved - to get Access to pass to Word .FormFields("FieldName").Result I needed to use legacy form text boxes and not the ones which were obvious.
Why does Microsoft not produce better documentation - I have wasted hours on this. I can't find any reference to anyone else having this issue.
Thank you to both JHB and arnelgp. Taking both your points in order of posting.
Comment out the 'On Error Resume Next' delivers an error dialog box '5941: The requested member of the collection does not exist'.
The 'Set doc = ActiveDocument' was an afterthought on a previous attempt to get it...
Hi! I wonder if anyone can help work out what is going wrong with this code. I am trying to fill a Word document (Insurance Form) by putting text fields in their table document and filling it from a stored procedure. Every request is a single one so I request the relevant numbers using input...
