populate field in a form based on user???

[DCV0204]

I have a main form that lets say 4 staff enter information; on the form I have a field called "LtrSentBy". When this form opens I would like for this field to be pre-populated based on the user. The field is currently just a text field, but I can make it a combo or list box. What is the best way to accomplish this?
Thanks,
Lisa

[alansidman]

In the on load event for your form, insert the following code.

Dim strValue as String
strValue = ENVIRON("username")
me.LtrSentBy.Value = strValue

This will automatically populate the text field with the windows user name.