Results 1 to 3 of 3
  1. #1
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283

    Filtering for uncontacted records

    I have a form with a subform and each have a last updated date field that gets set to Now() when a user makes a change to them. I the have a field that looks at all of the last updated dates and displays the Max of Last Update Date using =DMax("[Last Modified Date]","UnionTables","Account='" & [Account] & "'"). The fields name is MaxOfLast Modified Date.

    I have a button that when clicked I want to return all recrods where the MaxOfLast Modified Date field is null. But I can;t seem to get it to work.

    the onclick looks like this
    Code:
    Private Sub Command395_Click()Me.Filter = "IsNull([MaxOfLast Modified Date])"
     Me.FilterOn = True
    Me.Requery        
    End Sub
    But when I hit the button it opens a parameter window looking for me to enter in a value into the MaxOfLast Modified Date field.

    How can I get the onclick to recognize the field as empty and just return those records.



    Thanks for the help as always

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    Quote Originally Posted by orange View Post
    Is this the same issue (found in the Similar Threads)?
    https://www.accessforums.net/showthread.php?t=66512

    yup and also by me. For some reason this fell out of my history......thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Filter a form for uncontacted records
    By mindbender in forum Forms
    Replies: 27
    Last Post: 12-11-2018, 10:52 AM
  2. Filtering Records
    By Alex Motilal in forum Forms
    Replies: 2
    Last Post: 09-27-2017, 06:11 AM
  3. Replies: 21
    Last Post: 03-14-2016, 01:33 PM
  4. Filtering Master Records and Subform Child Records
    By Nerther in forum Programming
    Replies: 6
    Last Post: 10-01-2013, 05:24 PM
  5. Filtering records with a combo box
    By joesmithjunior in forum Access
    Replies: 1
    Last Post: 12-18-2011, 03:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums