current user expression

Question

I'm trying to make a field in a table have the default value of the current user, so we know who created the record.  I thought it would be CurrentUser(), but that's not working.  I'm sure it's something simple that I'm missing.  Please help.

Thank you!

Answer 1

That worked!!!  I new it had to something simple that I was missing.  Thank you!!!  :)

Answer 2

So you need to do it in your form, if you can't do it in your table. I think that's the problem, that CurrentUser() is not usable on the table level. Try setting it as the Default property of the control on your form.

Answer 3

=CurrentUser() gives an error that it's an invalid expression

a table field doesn't have an On Current event???

Answer 4

It automatically changes it to ="CurrentUser" and I just get the text CurrentUser in the field.

And if you enter

=CurrentUser()

If that doesn't work. Try using the On Current event and code like:

If IsNull(Me.CurrentUser) Then

Me.CurrentUSer = CurrentUser()

End If

Answer 5

It automatically changes it to ="CurrentUser" and I just get the text CurrentUser in the field.