Re: Combo Box problems

Tech-Archive recommends: Speed Up your PC by fixing your registry

change your BoundColumn back to 1. change the expression in the calculated
control to

=[Combo62].[Column](1)*[Text56]

note that the combo box column index is zero-based, so the first column
(from left to right) is zero (0), the second column is 1, the third column
is 2, etc.

hth


"Mike" <reply@xxxxxxxxxxxxxx> wrote in message
news:NeednX64nv5wMrvZRVn-sg@xxxxxxxxxxxxxx
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.




.

Relevant Pages

  • Re: Combine 2 fields and save in the same table
    ... If you had Price and Qty, you wouldn't save TotalCost ... Segment and Location is found. ... Control Number - QAT1/002 ...
    (microsoft.public.access.forms)
  • Re: transfering calculated records from forms to tables
    ... you don't save the result of a calculation to your ... Price and Qty are bound controls, ... Place a text control on your form, ...
    (microsoft.public.access.forms)
  • Re: Calculated Field question-need help asap
    ... Let me use the example of Price * Qty = LineTotal, ... Place a bound text control on the form. ... that go into your particular calculation. ...
    (microsoft.public.access.forms)
  • Re: What Is The Goal?
    ... A single payer plan which is tax based would reduce the cost for most. ... What I believe is that whenever "someone" else pays for the cost of ANYTHING that we need or want, we have taken the rationing decision out of the hands of the person who needs or wants that product or service, and gave that decision to the one paying the bill. ... The basic reason why government rations care, is to keep control of their cost growth. ... Under the current system, YOU never get to control the price, since you are paying for the profit of a non-essential middleman. ...
    (soc.retirement)
  • Zimbabwe - Pol Pot Revisited
    ... Zimbabwe suddenly looks like it has been in a war. ... In a week of frenzied activity the price of the US dollar went from about ... them are now under the control of either the State or Zanu PF elements who ... control the vote in these areas by these means. ...
    (soc.culture.zimbabwe)