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