Tim,
In addition to Vlad's method, you can run the SELECT to a cursor and assign the cursor as the rowsource:
select office from office1 into cursor pTemp
thisform.list1.rowsource = 'pTemp'
thisform.list1.requery()
HTH
Barbara
>In a listbox, I have the rowsourcetype set to SQL. in a cmdbutton I have
>
> WITH THISFORM.lIST1
> ROWSOURCE= "Select office from office1 INTO CURS PTEMP"
> ENDW
> thisform.refresh
>
>but it does nothing unless I hardcode the listbox's rowsource with
>"Select office from office1 INTO CURS PTEMP"
>
>Is this the way to go about it?