<div>
Pat,<br />
<br />
I should have been more specific regarding the LastModUser field. &nbsp;I meant the computer logic name. &nbsp;There is no database login form. &nbsp;How would I do that?
</div>


Pat,

I should have been more specific regarding the LastModUser field.  I meant the computer logic name.  There is no database login form.  How would I do that?

<div>
Both very helpful. &nbsp;Thank you.
</div>


<div>
<div class="content wysiwyg-content">
I have two field in a table... &nbsp;LastModUser (short text field) and LastModDate (short date field). &nbsp;When the record is either added or modified I want the LastModUser &nbsp;field to be populated with the user's login and I want the LastModDate field to be populated with the current date (short date).<br />
<br />
How can I do this? &nbsp;I assume it will be in the beforeupdate event of the record? &nbsp;Or?<br />
<br />
--Steve
</div>
</div>


I have two field in a table...  LastModUser (short text field) and LastModDate (short date field).  When the record is either added or modified I want the LastModUser  field to be populated with the user's login and I want the LastModDate field to be populated with the current date (short date).

How can I do this?  I assume it will be in the beforeupdate event of the record?  Or?

--Steve

Add data to table field when record is modified

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.