Sorry, the last line should read RowSourceType = 3.

Arriyel

>Try it with an 'INTO MYCURSOR' in the select statement. Also, we used we do the following:
>

>	.RowSourceType = 0
>	.RowSource = lcSQLStatement
>	.RowSourceType = 6
>

>
>HTH,
>Arriyel
>
>>I have two comboboxes, Depending on what I select in combobox1, it populates combobox2 called cboother. In the combobox1.interactivechange I have the following code to populate cboother combobox:
>>

>>				lcSelect =	[SELECT DISTINCT O_ord_pay.op_vendor] +;
>>							 [FROM dbbudget!o_ord_pay]+;
>>							 [WHERE O_ord_pay.op_flag_1 = 3]+;
>>							   [AND O_ord_pay.op_flag_2 = 4]+;
>>							 [ORDER BY O_ord_pay.op_vendor]
>>				.cboother.rowsource = ''
>>				.cboother.rowsource = m.lcSelect
>>			 	.cboother.requery()
>>

>>
>>My problem is that cboother is not populating with results (there should be 3 items showing up) from the sql statement built in lcSelect, the rowsourcetype on cboother is 3 - sql statement. Does anyone know what I am doing wrong?
>>
>>Thanks
>>Nick Patel