Thanks, 2 responses did solve my problem.
While I have you, Cannot I disable a cmdbutton and other objects on my form?



>Hi!
>
>Use following lines to refresh ListBox with SQL row source:
>
>WITH THISFORM.lIST1
>.ROWSOURCE = ''
>.ROWSOURCETYPE = 0
>.ROWSOURCETYPE = 3
>.ROWSOURCE = "Select office from office1 INTO CURS PTEMP"
>ENDW
>
>HTH.
>
>>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?