Question:
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?
Answer:
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.