Combo box values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with several feilds, including a combo (cboRate) . cboRate is
based on tblRate. tblRate has 3 colums: RateID (Autonumber), Code (Text),
and Rate (Currency). What I'm trying to do is to have the user choose a rate
from the combo, enter number of items sold, , and then have the field
'AmtDue' autofill. Currently I have this code in the AfterUpdate event of
the Sold field:

Private Sub Sold_AfterUpdate()
Me.AmtDue = (Me.Sold - Me.Returned) * CboRate
End Sub

The problem is that it multiplies by the RateID column of the combo rather
than by Rate. I understand why and I know there's a way to have it reference
a different column in the combo box because I've done once it before. But I
can't remember how!

Thanks for any help!

Tara
 
Back
Top