Combo Box problems
- From: "Mike" <reply@xxxxxxxxxxxxxx>
- Date: Sun, 26 Mar 2006 10:15:11 -0500
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 here is the
problem. If any of the values are the same for the price the text doesn't
change when a new item with the same price is selected.
I have changed all of the values so they were different and it works great.
Unfortunaly a lot of the items have the same value so i need to make this
work.
Im sure there is a way to do this and probably an easy one at that.
Any help would be appreciated.
.
- Follow-Ups:
- Re: Combo Box problems
- From: tina
- Re: Combo Box problems
- Prev by Date: Re: Suppressing "Importing..." Message Box for a Linked Image in a Form or Report
- Next by Date: Re: ComboBox ListIndex changes to -1
- Previous by thread: Run-Time Error 2001 Importing Linked Images with Mouse Snap-To Turned On
- Next by thread: Re: Combo Box problems
- Index(es):
Relevant Pages
|
