Anyone ever had issues with an EpiCombo going Blank on Focus? I have used EpiCombo’s many times, this is something new to me. I have tried obviously all types of DropDown Style Combinations (DropDown, DropDownValidate).
I also made seperate EpiCombo’s which I use as .ValueList on a GRID. Previously I used the same Combo that I used on the Form, on a Grid. But assuming that was the cause for blanks - I decided to create new EpiCombo’s which are hidden and assign as .ValueList to a grid… that didn’t help.
It happens frequent, but not always which is the odd thing! If I refresh the Form the values are set back, they are valid CodeID’s, Valid Values! Which makes it even more odd.
NOTE: All of these Combos are pulling in the same CodeTypeID, Perhaps Epicor struggles with that?
I narrowed it down to the Description Field. It will only STICK if you have a DescColumnName, which is stupid because you have to create another _c Column which you will not really use.
Thats an option. It looks like an Epicor Bug, because I remember in E9 you only needed a ValueMember, in E10.0.700 you needed both otherwise it would be grayed out, and in E10.1.500 you need both if you want it to stick, but only ValueMember is required, bug buggy sigh
Does it bark at you if you use the same field for value and description?
And did you mean “don’t”? edit oh, by stick, you mean work correctly. (I was thinking you meant stick as in broken. Too much mechanical in my head thinking sticky=bad)
One thing that Epicor does with their own Combo’s they create temporary Description Columns in their GetList, GetRows Procs, hence their columns don’t have an issue. Been Reflecting on over 50 Combos thus far, they all have a magical temporary Desc Column
But if you assign it a Description column, it will stick and not get cleared… But that means you would need always to make a Code, Desc Column in your Extended UD Tables… Or perhaps, create a temp column.
If I add that extra field in there it still does it for me, what’s more, I notice that if I select a row in the grid, then hit save, it clears the box. It all very erratic and very easy to mess up records.
When we use UserCodes for combos we used the standard “Description” field as the human readable field for the DescColumnName value. The CodeID was generally auto incremented.
Well the DescColumnName is the EpiBinding it should use to store the description. When you create a MyField_c the only thing I can think of is you have to create another field MyFieldDesc_c.
Of course for ValueMember we use CodeID and CodeDesc for DisplayMember.
Here’s an idea, if the issue only occurs when multiple combos are bound to the UserCodes, just use one for that, then on your other combos, simply clone the valuelist from the working one.