Results 1 to 3 of 3

Thread: Filter in form

  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I get th error invalid use of null.
    Me.FilterOn = True
    Me.Filter = Me!ltr > 0


    I want to filter the form showing only the products with ltr>0
    Can yo hlp me with the error ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The Filter property should be a text string that represents the WHERE part in an SQL statement. Try changing

    Me.Filter = Me!ltr > 0

    to

    Me.Filter = "ltr > 0"

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='799316' date='22-Oct-2009 08:49']The Filter property should be a text string that represents the WHERE part in an SQL statement. Try changing

    Me.Filter = Me!ltr > 0

    to

    Me.Filter = "ltr > 0"[/quote]


    Thank you for the advice the result is OK !!

Posting Permissions

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