If I'm not mistaken, I shouldn't have to create these cursors at all, the cursors should be created during the init of the dropdown since they are defined in the dropdown as a SQL statement (and dropdown RowSourceType = 3).


>You have to create these cursors in form's load. Init of the comboboxes happen before form's Init.
>
>>The cursor names are all unique:
>>
>>combo1 - select ... pplans
>>combo2 - ... paplans
>>combo3 - ... splans
>>combo4 - ... saplans
>>
>>Is there a point that I could debug to see if the cursors are ever being created at all. In other words, is there a way to tell if the cursors are just not being created as opposed to being created and then wiped out?
>>
>>If i set a break point in the init of the control itself, would the cursor have been created at that point? I can't do it at the form's init because by then, they definitely don't exist.
>>
>>>Are you using the same cursor name in all selects? The cursor names should be unique.
>>>
>>>>I have 4 combo boxes on a form. Each one is set to RowSourceType of 3 - SQL Statement. The RowSource is a valid SQL select statement with each box querying into a different cursor.
>>>>
>>>>In the init of my form, I run a method that tries to access some data in the 4 cursors. However, only the cursor from my first dropdown has been created. I can correct this by adding:
>>>>
>>>>

>>>>thisform.cboBox2.requery
>>>>thisform.cboBox3.requery
>>>>thisfrom.cboBox4.requery
>>>>

>>>>
>>>>in the init of my form. However, it seems like that should not be necessary.
>>>>
>>>>Is there something I'm doing wrong? What would keep those cursors from being created during the init of the control itself? Would a when or valid clause keep the control from creating the cursor during it's init?
>>>>
>>>>Thanks so much for your help!