Just add another column to the Combo like this:
Select Description, Part_id, Value from MyItemTable into cursor ComboRowsource order by 1
CBO_PartId::init
with this
.ColumnCount = 3
.Columnwidths = 200,0,0
endwith
CBO_PartId::InteractiveChange
this.ProgrammaticeChange()
CBO_PartId::ProgrammaticChange
thisform.Value = val(this.list(this.listindex,3))
I hope this works for you.
Glenn
>I have a form with the following methods (among others):
> Part ID - Combo Box - Row Source is a cursor - control source is Part ID
> Quantity - Spinner
> Charges - Text box
>
>When I selec t a new Part ID, the Charges should become the Price of the part times the Quantity. The Charges needs to update when a new part is selected before exiting the field. Charges = Price for the Part ID times the Quantity. The user needs to
>
>Methods:
> Click - The record pointer has not moved and the Value property had not yet updated. The new base price of the part cannot be acertained.
> InteractiveChange - The record pointer has not yet moced so the base price is not yet known.
> Valid - The record pointer has moved but, it fires even if the user has not sele cted a new Part ID.
>
>Does anyone know of a method that fires after the record pointer has moved, the control source has been updated and before the focus has moved?