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

    filter (Access 2000)

    My filter command does not do the job.I wanted to filter the records in the form to show only those records where the field Customerid is 1902
    I put the following command|:
    Me.FilterOn = True
    Me.Filter = Me!Customerid = 1902
    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 (Access 2000)

    The argument to Me.Filter must be a string, and you cannot use the keyword Me in this string.
    I'd set the filter first, then turn it on.

    Me.Filter = "CustomerID = 1902"
    Me.FilterOn = True

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filter (Access 2000)

    Thank you ! Excellent !

Posting Permissions

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