How can I automatically put the current user into a field?

[Guest]

Hello all,

In my table, I want to have a field that says "Updated By" and another that
says "Update Date". Anytime changes are made to the record, I would like the
current user's name and the date to get put into those fields. Does anyone
know how to do this or at least point me in the right direction?

Thanks
David

 

[Al Camp]

Use the forms BeforeUpdate event...
UpdatedBy = [currentuser]
UpdateDate = Date
hth
Al Camp

 

[Guest]

Question: Where does [currentuser] come from? Is this in a table?

Use the forms BeforeUpdate event...
UpdatedBy = [currentuser]
UpdateDate = Date
hth
Al Camp

Hello all,

In my table, I want to have a field that says "Updated By" and another
that
says "Update Date". Anytime changes are made to the record, I would like
the
current user's name and the date to get put into those fields. Does
anyone
know how to do this or at least point me in the right direction?

Thanks
David

 

[Guest]

Hello all,

In my table, I want to have a field that says "Updated By" and another that
says "Update Date". Anytime changes are made to the record, I would like the
current user's name and the date to get put into those fields. Does anyone
know how to do this or at least point me in the right direction?

Thanks
David

 

[bob]

a simple, straightforward way is to make the user logon via a startup form
and pick up that info..see http://www.databasedev.co.uk/login.html

alternatively you could take this approach:
http://www.databasedev.co.uk/get_username_or_computername.html

Bob Galway