>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?
>
I think your cursors are being created. You need the Requery calls to repopulate the combos after the cursors are created.
Tamar