Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    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
    Thanked 31 Times in 31 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.
    Me.Filter = "DeltaNew = 0"
    This will only display records with DeltaNew = 0. If you also want to display records where DeltaNew is null (blank), use
    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