Combo Box Values (1 Viewer)

dttate66

Registered User.
Local time
Today, 08:32
Joined
Feb 16, 2018
Messages
36
I have a combo box that list these value;

None
Mgmt. Fee (2%)
Mgmt. Fee (5%)
Mgmt. Fee (10%)
Mgmt. Fee (15%)
Mgmt. Fee (20%)
Mgmt. Fee (25%)

How can I get the text box to calculate in these as fees in my total when I choose one.

Thanks,
David
 

MarkK

bit cruncher
Local time
Today, 06:32
Joined
Mar 17, 2004
Messages
8,181
You want to make a 2 column combo, with a pure number in a hidden column, and that text in the visible column. To do this you'll need to use the ColumnCount property and the ColumnWidths property of the combo. Then you want to bind the combo's value to the value of the hidden column. For this, use the BoundColumn property, but I would just leave this = 1, and make your hidden column the first one. Then when you select the visible text, the value of the combo becomes the value of the hidden numeric column, and you can just use the name of the combo in your expression to return the numeric value in the selected hidden column.
hth
Mark
 

dttate66

Registered User.
Local time
Today, 08:32
Joined
Feb 16, 2018
Messages
36
Thanks MarkK, after reading your reply I realized I was over thinking the problem, I had used that exact same avenue you just told me for another combo box, just with alpha data.

David
 

Users who are viewing this thread

Top Bottom