Need help with textbox's

[Guest]

Simple question for Access 2000,
I have a textbox on a form that display's the current date and the control
source is set to the date on the table. I then have another textbox on the
same form set to display the day of that date entered and it's control source
set to day on the table. I would like the day to automatically change to the
date entered but then be sent to the table. I tried adding a third text box
to change the day that is entered, which works but will not get added to the
table since it's control source is set to textbox 2. So i tried adding a
fourth textbox and it's control source set to the third textbox changed day
but it doesn't change and doesn't get added to the table. I was going to hide
all the other's and just display the one that gets changed and sent to the
table.

Examples....

(textbox 1) Date: 01-09-2006 <-- this control source is set to date in table.
(textbox 2) Day: Monday <-- this control souce is set to day in table.
(textbox 3) Day: Monday <-- this control source is set to textbox 2.
(textbox 4) Day: Monday <-- the control source is set to day in table, and
default value is textbox 3.

But this is what happens if i change the date in textbox 1.
(textbox 1) Date: 01-10-2006
(textbox 2) Day: Tuesday
(textbox 3) Day: Tuesday
(textbox 4) Day: Monday <-- this one doesn't get changed or added to table.

Is there another way to do this or am i on the right track but just missing
something?

Thanks,

Steve K.

 

[Guest]

Sorry i typed the last part wrong it shows up like this when i change the date.

(textbox 1) Date: 01-10-2006
(textbox 2) Day: Monday <-- this one doesn't get changed or added to table.
(textbox 3) Day: Tuesday
(textbox 4) Day: Monday <-- this one doesn't get changed or added to table.