Not sure I'm clear yet. Can you show us the code you're using for the export? If you're doing it manually using the Ribbon, could you describe the steps you take? Thanks!fields from a form, that go into a word document for printing out.
Hi. Thanks for posting the code. For the combobox controls, you can use the Column property to grab the displayed value instead of the bound value. For example:sorry, so new to this, let me me see if this works.
But I think MajP might be on to something
.FormFields("DropDown1").Result = Me.PET_TX.Column(1)
Hi. Since I was just guessing which one is a combobox, please make sure you pick the right one and use its name, okay? Also, just FYI, Column index is zero (0) based. So, if you want the 3rd column, use 2. Cheers!ok, let me give it a try
Can you show us an example of how you implemented it? Thanks!unfortunately my word fields are now empty after adding ".Column(x)"
checked correct column and correct spelling etc.
Hi. Glad to hear you got it to work. Good luck with your project.Ok, so i changed them all to column(1) and it works??