>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