Switching controlsource

[giant56]

Sorry for so many post, I'm been having problems of late. My new problem is switching the controlsource for a text box after running a filter. Right now I am using a macro to try and do the following.

Apply filter, where I filter the projects I want. (This works fine)

Then I try to SetValue, where I try to make text6, equal the value in a field. I have seven fields and I don't want to make a text box for each one. When I try to setvalue it tells me it can't automate the controlsource property. If anyone knows how to change the controlsource of a text box, through a macro preferably, but code will work too, while in form view please reply.
My fields are PCT Deadline, Bar Date, Chapter II Deadline, National Deadline, First US Annuity, Second US Annuity, and Third US Annuity.
Please Help me I am desperate.

 

[giant56]

Everything is working great. You are a god. Now one last question I want to apply a filter query named "PCT Deadline". How do I go about this in Visual Basic code. As of right now my code is

DoCmd.ApplyFilter (Me![PCT Deadline])

This is not working for some reason. It is telling me it can't find the field "PCT Deadline", but I have it in my queries.
Thank you very much in advance.

[This message has been edited by giant56 (edited 06-08-2001).]

[This message has been edited by giant56 (edited 06-08-2001).]