Endojoe
Registered User.
- Local time
- Today, 16:17
- Joined
- Apr 7, 2009
- Messages
- 20
Good Day All,
I have a table sourced Combo Box on a Form and it populates several Text Boxes and Option Groups using the following code:
Unfortunately, column 5 often has no data in it, and because of that, for reasons I do not understand, the code appears to quit running when it encounters an empty column (or null column, if this is an appropriate instance to use the term). So, where ever I place the empty column in the code, nothing is filled in after it. I would place it at the end of my code, which is something I've done in other Combo Boxes as a quick dirty work around. But in this instance, Column 5 and Column 6 both are empty sometimes, other times only Column 5 is empty when Column 6 has data in it, and vise-a-versa. I've searched the Forum as best I could and not found anything that seems to answer my problem. I wasn't sure if this should go in the 'Forms' section or the 'Modules & VBA' section, so Mods, please feel free to move this if you feel it is better placed somewhere else.
Thank you all in advance for your help!
-Will-
I have a table sourced Combo Box on a Form and it populates several Text Boxes and Option Groups using the following code:
Code:
Private Sub cbo_CUSTOMER_NAME_AfterUpdate()
Me.Txt_Country = Me.cbo_CUSTOMER_NAME.Column(1)
Me.opt_Cert_Type = Me.cbo_CUSTOMER_NAME.Column(2)
Me.opt_Assy_SubAssy = Me.cbo_CUSTOMER_NAME.Column(4)
opt_Assy_SubAssy_AfterUpdate
Me.opt_Export_Domestic = Me.cbo_CUSTOMER_NAME.Column(3)
opt_Export_Domestic_AfterUpdate
Me.txt_ADDL_STATEMENT = Me.cbo_CUSTOMER_NAME.Column(5)
Me.txt_TRACK_NUMBER_CERT = Me.cbo_CUSTOMER_NAME.Column(6)
End Sub
Unfortunately, column 5 often has no data in it, and because of that, for reasons I do not understand, the code appears to quit running when it encounters an empty column (or null column, if this is an appropriate instance to use the term). So, where ever I place the empty column in the code, nothing is filled in after it. I would place it at the end of my code, which is something I've done in other Combo Boxes as a quick dirty work around. But in this instance, Column 5 and Column 6 both are empty sometimes, other times only Column 5 is empty when Column 6 has data in it, and vise-a-versa. I've searched the Forum as best I could and not found anything that seems to answer my problem. I wasn't sure if this should go in the 'Forms' section or the 'Modules & VBA' section, so Mods, please feel free to move this if you feel it is better placed somewhere else.
Thank you all in advance for your help!
-Will-