>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