I have a very handy bit of code that I use to enter the login information of the person completing a form.
It is in the default value of the field and it enters the AD logon.
What I am trying to do now is use the same code to enter the login information of the person who opens the form at a later date.
So the first time the form is created the default value is the windows logon for this example we will make it 554433 the form is saved with the additional data. This form is a request that something be done.
Now the request has been completed so another someone we will give them a windows logon of 998877 opens the form to mark it complete.
I can no longer use the default value because it is not a new form so I thought I could create a completed button that would run the module and enter the new windows login of 998877 in a different field.
I cannot get this to work.
My field name is CompletedBy
The Module name is modOSUseraName
the function is fOSUserName()
Should I create a macro for this to run the module?
Thanks,
Tina
It is in the default value of the field and it enters the AD logon.
What I am trying to do now is use the same code to enter the login information of the person who opens the form at a later date.
So the first time the form is created the default value is the windows logon for this example we will make it 554433 the form is saved with the additional data. This form is a request that something be done.
Now the request has been completed so another someone we will give them a windows logon of 998877 opens the form to mark it complete.
I can no longer use the default value because it is not a new form so I thought I could create a completed button that would run the module and enter the new windows login of 998877 in a different field.
I cannot get this to work.
My field name is CompletedBy
The Module name is modOSUseraName
the function is fOSUserName()
Should I create a macro for this to run the module?
Thanks,
Tina
Last edited: