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?