>>>>I was hoping to unbind a dbf from a listbox during the listbox's click event. Can this be done with a
>>>>".RowSourceType=2
>>>> .RowSource=""
>>>> .rowsource= '' " command?
>>>
> WITH THIS
> .RowSourceType=2
> .RowSource=""
> .rowsource= ''
> .Requery()
> ENDWITH
Jim, the () after .requery is illegal so I omitted it.
my code looks like this in the click section:
THATOFF=THISFORM.MYLISTBOX2.VALUE
With Thisform.myListbox2
.RowSourceType=2
.RowSource=""
.rowsource= ""
.Requery
Endwith
copy stru to c:\query && should be unbound but....
sele select(0)
use c:\query
TMETH=thisform.mylistbox1.value
thing=allt(thisform.mytextbox1.value)
appe from M:&THATOFF for thing $ &TMETH
NOW on the tmeth line it bombs out with the message
"record is out of range" HELP!
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."