Thanks for your response.

I create module with your code. and put beforeinsert and beforeupdate
event code

Me.WhoCreated = User_FX
Me.WhoModifies = User_FX

it is not inserting / recording whocreated and whomodified
username into table.

I also try above code / procedure in Windows XP operating system and
ms office 2007 access db. but same problem, it is not recording the
username. whocreated and whomodified.
it is only recording the datetime.

Can I get sample (small db,one form one table) which record the username of data entres?

thanks and regards

Mateen
[email protected]

Thanks you very much for sample db.
It is working in vista ms office 2007.

I am trying to use this code in my db to collect the userid information.

Regards
Mateen