Related text boxes

[Wrightmans]

I have 2 text boxes named Sday and Sdate in a form. The value in Sday is automatically set when the date entered in Sdate box . The code I use is (=WeekdayName(Weekday([SurveyDate],2)) ) which I put it behind Sdaye “Control Source” is :

It works fine, however no data is saved in Sday (only visually) and when I try to print its value i.e. in a report its empty. Could someone pls tell me where do I go wrong?

 

[PHV]

no data is saved in Sday
Why would you store a calculated value that you can easily retrieve in a query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Wrightmans]

Thanks PHV for reading my post. Not even in a query you would be able to see the value, its like its only stored in the form. Is there any way to do it az in my first question? thanks

 

[PHV]

Have a look here:

http://r937.com/relational.html

(Third Normal Form)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886