Passing contents from a textbox to a variable

[ProNetGroup]

Does anyone know how to do this?
I am trying this:

strSQL = txtTemp

but it keeps returning a null value, for both the textbox and strSQL. When I comment this out and run the code, I can see that the textbox IS NOT null and has the data I need in it, so what gives???

 

[Junior1544]

try this:

strSQL = me!txtTemp


also, this must be done from vba...

junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[jebry]

Hi!

Where is this code? If it is in the BeforeUpdate for the text box then the value will not be recognized yet since it has not been saved. In that case try using Me!txtTemp.Text.

If you are using any form event that occurrs after the record has changed such as Current then the value will not be availble then either.

hth
Jeff Bridgham
bridgham@purdue.edu