Re: Using IN Operator in ADO Rs.Filter ?



No, although to a limited degree you can use Boolean logic:

InvoiceNo=123 OR InvoiceNo=345


You can also set the Filter property to an array of bookmarks, which
may be suitable, depending on why exactly you needed the filter in the
first place.

g.

.



Relevant Pages

  • Re: find button to look in specific place
    ... Use it to set the Form's Filter property: ... where txtFindName is the name of an unbound textbox on your form. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • RE: selecting records from particular date
    ... Use your form's Filter property to filter on the date. ... "Manoharan PM" wrote: ... > how to select records from my database by giving a specific date. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • query filter
    ... I've got a query without WHERE part. ... I see there is filter property for form but what if I deal with ... list box and it's corresponding query (record source). ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)