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