ComboBox Query Problem..

[Siddiq]

I am using a combobox in my form and using a query in it..
when I run that form it shows me a query window. I want to disable that query window.

 

[Creeder]

Hi Siddiq,

Try doing something like

SELECT * FROM <table> INTO CURSOR tmpCursor
That will prevent the browse window from opening.

You then can basically use the cursor like a table.

Hope that helps

Yue Jeen

 

[Siddiq]

Thanks Creeder..
It's working but how to keep the cursor in order

 

[Creeder]

Hi Siddiq,

You basically can do something like this,

SELECT * FROM customer ORDER BY name INTO CURSOR tempCursor

Therefore you have a table/cursor sorted by the column name.

You then can manually assigned the Rowsource of the combo box to this cursor.

Hope this helps.

Yue Jeen