GetUser()

[hitesh_asrani_j]

I have a user form.... it takes two values Username and Password.
That user name is saved globally using a Module...
A new form is opened after that UserForm..
Now it contains a field which takes the value of that Username using that Module with the help of the function =GetUser()

But wheni try saving that record into a table that particular field shows blank:|



Can anyone hlp...

[June7]

Textbox ControlSource set to an expression will not save the calculated value. Must use code.

If the field is in the form's RecordSource and current record is the one that needs the value, simply:
Me!fieldname = Me.textboxname
or
Me!fieldname = GetUser()

[hitesh_asrani_j]

Where do write the following code???
In the Control Source from the properties pane???

[June7]

Need to decide what event to use for the code, such as a button Click or the form Close. On the Event tab choose event and select [Event Procedure]. Double click the ellipses (...) to open the VBA editor. You will be in the procedure. Type code there.

Here is possible alternative. Use the GetUser() function in the DefaultValue property of textbox. Set textbox ControlSource to the field. New record will populate field with the default value.

[hitesh_asrani_j]

It solved :d