M
Mike
I have a combo box that im using to display 2 values from a table.
When clicking on the down arrow of the combo box im displaying the item
description in the left column and the corresponding price in the right.
I then have a text box next to this field called "Qty." where im entering in
the qty of items.
I then have a third text box called "Charge" that i want to have calculate
the price * Qty value and display it in this field.
Im having a heck of a time getting this to work properly.
It somewhat works with the following as the control source for the "Charge"
text box: =[Combo62]*[Text56].
I have to set the Bound Column value for the combo box to 2, but then i lose
the Item descriptions from the pull down menu.
Im sure there is a way to do this and probably an easy one at that. Any help
would be appreciated.
When clicking on the down arrow of the combo box im displaying the item
description in the left column and the corresponding price in the right.
I then have a text box next to this field called "Qty." where im entering in
the qty of items.
I then have a third text box called "Charge" that i want to have calculate
the price * Qty value and display it in this field.
Im having a heck of a time getting this to work properly.
It somewhat works with the following as the control source for the "Charge"
text box: =[Combo62]*[Text56].
I have to set the Bound Column value for the combo box to 2, but then i lose
the Item descriptions from the pull down menu.
Im sure there is a way to do this and probably an easy one at that. Any help
would be appreciated.