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!