coding a combo box contents

[kkpen]

I would like to have a combo box that populates with data, here is the code i have that don't work:

forms!frmdbxSortCriteria!cbxFindSort.rowsource = "qryAddcbxFindSort"

now the qry has several colums that i will set in the propertys to show 2 colums and bound to colum 1. I have a IF THEN that determines the data that is shown in the combo box and I need the code above to set the data, as i can't do it in the combo box propertys.

Thanks

 

[shay]

Hi there

Where are you specifying the rowsource? If it is in Properties, the query name shouldn't be in quotes.

hth

shay

 

[kkpen]

The row source command is in vba code on a popup form that gets hidden and not closed to later.