Results 1 to 2 of 2
  1. #1
    tagteam is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    486

    Search all records that linked sub form is filtering

    I have a form that has a list of cars and a sub form of when all the cars were assigned out and their begin and end dates. I need to be able to search for any car that has an end date before X date. However, since the main form is just the cars the dates in the subform are filtered to be the dates for just that one car. I would like to be able to filter or find or whatever so that when I am on that car I can still search and see all the cars with an end date before X date.



    Not sure if I am explaining it very well.

    Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Need to use a different form or generate a report.

    Maybe another subform that is not linked to the main form.

    There will be multiple records for begin and end dates for each car?
    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: 3
    Last Post: 11-04-2012, 09:25 AM
  2. Replies: 4
    Last Post: 07-11-2012, 10:31 AM
  3. Filtering records on a split form
    By Accessbeginner23 in forum Programming
    Replies: 1
    Last Post: 07-02-2012, 03:23 PM
  4. Replies: 15
    Last Post: 04-17-2012, 01:42 PM
  5. Replies: 2
    Last Post: 11-05-2010, 04:47 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