Global variable - Get a textbox value - Userform

Well, i would like to store a textbox value (dateformat) in a global variable and then use her value to find a specific data in my DB


so i wrote it:

IN MODULE 1:

'Set a global variable

Public glbdate As Date


'Create a function
Public Function globaldate()

glbdate = Format(dt_lan, "mm/dd/yyyy")

End Function


IN A TEXTBOX FIELD(Event afterupdate field):

Call globaldate 'call function to get the date


IN A COMMAND BUTTON:

cnctnate = glbdate & manline & model 'Im trying to get the value

IDK what's going on, but it's not working. HELP PLS!
Thanks,

What's dt_lan?

Also, why do you need a global variable?

I'm not sure why you need/want a global variable, also I'm not sure what the purpose of the function globaldate is, all it seems to do is format a date.

Where is the code to search the database located?

The global variable gbldate is data type Date
The value of the text box is a string.

Rather than passing through the Format function, the text box value should be run through CDate function.

Please Login or Register  to view this content.