Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox with SQL RowSourceType
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00612945
Message ID:
00612951
Views:
20
This message has been marked as the solution to the initial question of the thread.
>I have a list box using RowSourceType - 3 (SQL). The RowSource is:
>
>
>select ffield, fcondition, fvalue from InvRptFilter where fsessionid = thisform.sessionid into cursor cFilter
>
>
>When the form loads I get an error "thisform can only be used in a method" however, when I add some records into invrptfilter and requery the listbox, I don't get the error and the listbox displays the additional records as I would expect.
>
>Is there a better approach to using a filtered listbox?
>
>TIA!
>
>Rob


The listbox is instantiating before the form is known.
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform