Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Method Search
Message
 
To
28/10/2002 23:24:15
John Tomblin
Service Station Systems, Inc.
San Jose, California, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00716307
Message ID:
00720136
Views:
12
In the interactivechange event add code that seeks to the record that is shown in displayvalue.

Don't try to rely on a record pointer for the combobox. Populate the combobox with a SQL statement in the init of the combobox with the primary key as a hidden column. Then on interctivechange, get the key value from the combobox and seek() to the record with that key. If found() do the math and populate your textbox.

Cursors and alias' as a rowsource is unpredictable unless you want to take the time to study the sequence of events in a combobox interactive change.

>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?
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California
Previous
Reply
Map
View

Click here to load this message in the networking platform