Cetin,
Thank you for the advice.
>>I have a dropdown list combobox with the following SQL statement as the RowSourceType:
>>
>>SELECT * FROM metadata NOCONSOLE WHERE datafield = "cboRef"
>>
>>The Table "metadata" is placed in the Form's DataEnvironment. When I start the form, the results of this SQL statement appear in a browse window just before the form displays. How do I avoid this? I thought that's what the "NOCONSOLE" instruction is for. I know I can have the result set go to a cursor. But I prefer it not to, as I will have several other ComboBoxes using the same "metadata" table and similar SQL statements as their RowSourceType and I don't want all these temporary cursors being opened if I can avoid it.
>>
>>Thank You.
>
>You should specify a destination :
>
>SELECT * FROM metadata WHERE datafield = "cboRef" into cursor crsCombo
>
>PS: With rowsource SQL you can't avoid a cursor to be opened.
>If you are using a private datasession this is not a problem IMHO.
>Cetin