Default Value Help

[quig699]

Hi,

I have a form that allows users to enter data for customers I have fields "Date Completed" & "Completed By". What I am looking to do is when the user populates the "Date completed" field I want to grab their network log in and put it in "Complete By" field.

I have tried to use the following code in the default value field of the "Completed By" field but it has not worked.

=IIf(IsNull([Date Completed])," ",FOSUserName())

This code does work if I use it in an unbound text box.

FOSUserName() is part of a module I have to obtain the network ID.

Any suggestions?



Thanks,

Amy

 

[PHV]

In the AfterUpdate event procedure of [Date Completed]:
If IsDate(Me![Date Completed]) Then
Me![Completed By] = FOSUserName()
End If


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[quig699]

Hi PHV,

Thank you for your quick response. It doesn't appear to be working. It leaves the Completed By field blank. Is there anything else I can try?

Thanks,

Amy

 

[PHV]

And this ?
In the AfterUpdate event procedure of [Date Completed]:

If Trim(Me![Date Completed] & "") <> "" Then
  Me![Completed By] = Environ("USERNAME")
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[randy700]

Make sure your [Date Completed] field is formatted as Date.

Randy