Mary,
You can change the rowsourceType to 'Alias', then at any point in time you can issue your select statement in code. SELECT into a cursor, and put the name of the cursor in the rowsource. Issue a listbox.requery() after the SELECT statement.
>I am trying to pass conditional variables into a rowsource in a combo box. Basically, what I want to do is adjust the 'where' clause by adding either nothing to it or an ' AND npropid = lnpropid'. I tried using an iif construction in the where clause, but that didn't work. Then I tried doing a 'TEXT TO variable TEXTMERGE' and putting the variable into rowsource, but that didn't work either.
>
Steve Gibson