I'm sorry I didn't explain my situation better. I have different projects due at different dates. At the bottom of my form I have a filter setup to display only the type of projects you select. I also have the field that displays the due date linked to a calender. Now in my macro I have the apply filter action, and now I need to somehow get the control source to link to a different project type.
My datasheet looks something like this:
PCT Date...Bar Date....Chapter II Deadlines
4-20-01....5-12-02................
6-6-98.....................6-02-00
5-12-02....................6-10-04
etc.
So as you can see, sometimes the dates aren't always going to be filled. So I've setup only one text box to display all the dates, and that is why I need to change the control source after I filter the information.
[This message has been edited by giant56 (edited 06-07-2001).]
[This message has been edited by giant56 (edited 06-07-2001).]
