Here's my problem. I have a form with a date text box. I have a different deadline for four different projects. How do I change the control source on a text box. It tells me it can't automate the form. Thank you for your help ahead of time.

Why do you want to change the controlsource?
Your table should consist of one Project field and one date field.

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).]

Use a query that joins the details table to the project table as the recordsource for the form. That way, all the fields associated with a project will be available for display on the form.