Results 1 to 2 of 2
  1. #1
    Fish218 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    68

    Clearing a subform filter

    Here's what I have:



    cboName

    cboThisYear

    subCatch

    subIndividual

    subIncTags

    cboName and cboThisYear filter subCatch. I select an existing record in subCatch (which puts "CatchID" in subIndividual) then add data to subIndividual. I then filter subIncTags based on a tag number typed in an unbound text box in subIndividual and use an afterupdate event in another field of subInividual to insert the date returned and other values in subIncTags. The problem I have is when I filter subIncTags using the unbound text box when I move on to another record subIncTags does not "refresh". In essence, how do I clear a filter in a subform? Can I use a DoCmd.GoToRecord to automatically insert the needed data in subIncTags? I'm stuck!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    How do you move to another record? The intrinsic Navigation bar? Or command button?

    Show code for analysis or provide db. Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 08-16-2012, 01:51 PM
  2. Replies: 6
    Last Post: 05-05-2012, 08:43 AM
  3. need to filter a column in a subform
    By gregu710 in forum Forms
    Replies: 6
    Last Post: 02-21-2012, 05:19 PM
  4. Filter subform
    By DCV0204 in forum Forms
    Replies: 1
    Last Post: 12-01-2011, 10:37 AM
  5. Pass Subform filter to subform in report
    By camftm in forum Programming
    Replies: 16
    Last Post: 07-19-2011, 07:12 AM

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