Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    2

    Unanswered: Showing only null records

    I've an Access query and a form using this query as data source.

    What I'm trying to do is; in the main menu, if user selects show records with specific value field is null then I want to show only those records.

    Normally in the query in criteria section if I write:
    "Is Null"
    It's working.

    But if I write something like that:
    IIf([Forms]![FRM_Menu]![Text11].[Text]="Show nulls",([Timing].[Sch_Intro_Date]) Is Null)

    It's not working.
    Can you please help me what I'm doing wrong?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I guess the way to handle this is to apply a filter
    something like:-

    Code:
    if  text11 = "Show nulls" then
      me.filter = "isnull([Timing].[Sch_Intro_Date])"
      me.filteron=true
    else
       me.filteron=false
    endif
    me.requery
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2014
    Posts
    2
    This helped, thank you.

Posting Permissions

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