Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RowSourceType = 6 Error
Message
From
05/03/1999 12:00:59
 
 
To
05/03/1999 11:49:08
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00194432
Message ID:
00194558
Views:
24
>This is the situation:
>
>I have a form for sales adjustment. The values of the controls on the form are initialized to the values of a record retrieved by a SELECT statement from a .dbf file to be adjusted.
>
>On this form I have a combo box called *cboDepartments* and another combo box called *cboDivisions*. A department can have multiple divisions. I want the original value displayed in the text portion of cboDivisions, and can't seem to get it to work properly.
>
>For the purpose of adjustment, when a department is selected from the list, a cursor (comprised of all divisions belonging to this particular department) is created in the LostFocus event of cboDepartments.
>
>Is my approach correct? Is there a better way to achieve what I'm trying to do here?

I guess that Combo.InteractiveChange event is better place to create a cursor then Lostfocus event. After cursor is recreated you should fire immediately:
Thisform.cboDivisions.requery
Thisform.cboDivisions.refresh
Thisform.cboDivisions.Value=.... && something which is part of this cursor
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform