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