🚀 go-pugleaf

I have spent hours on this and don't even know if it can be done.

I have a ComboBox on a form.  The form contains a DataModule.  The
DataModule contains an SQL file that selects two dbf files (cusmas and
transmas).

What is the proper syntax to use, in the filter propertyt of the
rowset, to filter based on the value of an entryfield (or var).  All
of the examples given in the newest version of the OLH are constants;
no vars.

Please see the "--->" comment in the following example code.

Thanks for the Help,
Tom Preston

////////////////////////////////////////////////////////////
** END HEADER -- do not remove this line
//
// Generated on 06/26/1998
//
class leaseDataModule of DATAMODULE
   this.LEASE1 = new QUERY()
   this.LEASE1.parent = this
   with (this.LEASE1)
      left = -0.1429
      top = -0.0455
      sql = "@leasmain.sql"
      active = true
   endwith

   with (this.LEASE1.rowset)
      beginFilter = class::ROWSET_BEGINFILTER
      applyFilter = class::ROWSET_APPLYFILTER

--->The following filter (being a constant) works fine.
--->But what would the syntax be if I wanted to filter
--->based on the value of "AnyForm.Cusnum.Value."

      filter = "tcusnum=1" 

   endwith

   this.QUERY1 = new QUERY()
   this.QUERY1.parent = this
   with (this.QUERY1)
      left = 3
      top = 2.5
      sql = "@leasecn.sql"
      active = true
   endwith

   function rowset_applyFilter
      return ROWSET::applyFilter()

   function rowset_beginFilter
      return ROWSET::beginFilter()
endclass