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)