Default Current User Date and Time in a form


I have a simple table (Date, Time, Agent, Notes) that I need to automatically enter the current date/time and Username into a record when the user finishes with the Note. How do I do this?


The easiest way would be to add this once information is entered into the note on a form. i.e. add the fields to a bound form by following the wizard.

Open the properties for the date field (right-click on the text box > properties).

Click on the 'data' tab - next to default. Type the following:

= date()

Do the same for the Time field, but type in:

= time()

For the agent field, type in:

= [CurrentUser]

Now each time a new record is created, i.e. information is added into the Note section then the preceding information is documented in the table/form.