0 Replies Latest reply: Oct 18, 2012 3:57 AM by Michael MA RSS

    How could the records not show if no values match?

      Hi all,

      Today i met a requirement and do the range selection via macro, i wanna to let the table box which contain the field 'Tbl_BDN_Reason.Id' show nothing if no values match a bit like the sql query script where clause script.  How could the function implement? Currently the vbscript below could do no selection for the field but show all values. (there is no '100' value in field 'Tbl_BDN_Reason.Id')       Appreciate ur help !

       

      -----------------------------------------------------------------------------------

      sub selectField

         rangstring=100  

         set f=activedocument.fields("Tbl_BDN_Reason.Id")

         f.select rangstring

      end sub

      -----------------------------------------------------------------------------------