Benjamin Bolduc
Registered User.
- Local time
- Today, 12:33
- Joined
- Jan 4, 2002
- Messages
- 169
I'm working on a complicated form that has three subforms in it. Multiple records are added everyday and I have it set so that only the records entered on that day show on the form. (To avoid the clutter of 100's of records building up). The problem is that some people who use this DB need to reveiw records from previous dates. I know how to do this simply by changing the underlying querys, but the people I work with barly know how to turn a computer on.
I'd like to add a control that, when a date is entered, would filter the contents of the three subforms to that date.
Not only that, but the report that is used to calculate and interpret the data needs to be filtered by this date as well. There is a control on the form to open this report.
I'm not sure if I need to make a query or add some VBA or what.
If anyone could offer some advice, it would be greatly appreciated. Thank You.
I'd like to add a control that, when a date is entered, would filter the contents of the three subforms to that date.
Not only that, but the report that is used to calculate and interpret the data needs to be filtered by this date as well. There is a control on the form to open this report.
I'm not sure if I need to make a query or add some VBA or what.
If anyone could offer some advice, it would be greatly appreciated. Thank You.
