currentuser to populate a field

[Paul Willliams]

Hi all

I have a quick question.... I would like the currentuser to populate a field
in a table. I have tried using the =currentuser() function without effect. If
i add it on a form then it defaults the whole table to that user. I would
like the current user to be recorded against each record

Does any one have any ideas how i can do this???

Cheers

Paul

 

[Nikos Yannacopoulos]

Paul,

Add a text field in the table to hold the user information; add a
textbox in the form, bound to that field, and set its default value to
=currentuser(). This will do it for all new records created. Note: the
textbox doesn't have to be visible!

HTH,
Nikos

 

[Duane Hookom]

This assumes that security has been enabled in the application.

 

[Paul Willliams]

Is there no other way.. Currently I have no security. This will be a later
addition is there another way.. Say to pick up the windows login????

 

[Duane Hookom]

You can use the function found at http://www.mvps.org/access/api/api0008.htm
as the default value of a control on a form.