gregoryenelson
New member
- Local time
- Today, 06:34
- Joined
- Oct 14, 2006
- Messages
- 5
I need to instantiate Word docs from Access VBA and read the data therein, and I can read the various controls but not the drop down choice that was selected by the user. Trawling the internet I could only find a way to access the index number that was used but it appears that there is no way to read the selected value with VBA. Does anyone know the code to do this ?
I know how to automate/instantiate Word 2007 from Access 2007. These Word documents were written before I started work here (using 2007) the 'drop down' control is a Form Field from the Ribbon.
It is only the syntax of the reference which I imagine would look something like this:
doc.FormFields("TheDropDownControl").Value
But of course that does not work.
I know how to automate/instantiate Word 2007 from Access 2007. These Word documents were written before I started work here (using 2007) the 'drop down' control is a Form Field from the Ribbon.
It is only the syntax of the reference which I imagine would look something like this:
doc.FormFields("TheDropDownControl").Value
But of course that does not work.
Last edited:
