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