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?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.