Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unbinding a dbf from a listbox
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00059324
Message ID:
00059775
Views:
29
>>>>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."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform