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:
Do the same for the Time field, but type in:
For the agent field, type in:
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.