Results 1 to 2 of 2
  1. #1
    alexandervj is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Posts
    145

    How can I filter a subform onLoad?

    I have a subform inside of a form. The form has info about an entire group of parts and the subform contains a list of all the parts in that group. What I want to do is just filter out the parts in the subform whenever the form/subform loads which do not have a 'deleted' checkbox checked. (No parts in the database get deleted; if someone deletes a part I just want it to add a true to the 'deleted' flag field for the part and then that part doesnt show up in regular part lists anymore). Thanks!

  2. #2
    alexandervj is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Posts
    145
    Nevermind, I figured it out. Just put an onload filter in the subform itself for [Deleted] = False. Wasnt sure if there was more to it than that since it was a subform of a parent form

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

Similar Threads

  1. Onload event doesn't work for filter
    By tagteam in forum Forms
    Replies: 2
    Last Post: 02-12-2014, 11:54 AM
  2. Access 2007 - Multiple Subform Onload
    By ilikebirds in forum Access
    Replies: 3
    Last Post: 12-10-2012, 02:48 PM
  3. Replies: 1
    Last Post: 08-16-2012, 01:51 PM
  4. Replies: 6
    Last Post: 05-05-2012, 08:43 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