control source

[Guest]

Prob a stupid question, when i type datediff function into the control source
of my cell it works fine, but how do i then get that information back to my
table considering the control source has the formula in it??

thanks in advance

 

[strive4peace]

Do not store calculations in your table -- you can calculate them anytime

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[pietlinden]

Prob a stupid question, when i type datediff function into the control source
of my cell it works fine, but how do i then get that information back to my
table considering the control source has the formula in it??

thanks in advance

why would you store a calculated value anyway? Recalculate on the fly
as necessary in a query.