Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filter in form (Access 2000)

    My filter command does not show me any results.I wanted to filter the records in the form to show only those records where the field DeltaNew is blank or 0.
    I put the following command|:
    Me.FilterOn = True
    Me.Filter = Me!DeltaNew = 0

    What is wrong with my command ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filter in form (Access 2000)

    The Filter property is a string. You must put quotes around it, and it should refer to fields in the record source, not to controls on the form.
    <code>
    Me.Filter = "DeltaNew = 0"
    </code>
    This will only display records with DeltaNew = 0. If you also want to display records where DeltaNew is null (blank), use
    <code>
    Me.Filter = "DeltaNew = 0 Or DeltaView Is Null"</code>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •