Specific Field Update

[Steven19]

I'm creating a Document Control Database.

The Database essentially is 2 tables.

1 Document Details
2 Version Control

I want to click a button, the control adds todays date to the date field when the update button was clicked.

The button is on a continuous form in the footer. the query filters the records to show all the historic versions for the document being viewed.

I'm not sure how to code the update.
My fields in the version control table are:

PK
FK
DocumentAmendment
Amendedby
DateAmended
Version


DateUpdated

If the query form shows 4 versions, I want to add the new record, I can do that, but I need to set the DateUpdated for record 4 to todays date.

Any pointers or methods I should use would be helpful.

[pbaldy]

Generally:

Me.ControlName = Date()

In your case

Me.DateUpdated= Date()

Presuming the textbox has the same name as the field.

[pbaldy]

I should add that the method could change depending on how you're adding the new record, but it would involve the Date() function (or the Now() function if you want the time included).

[orange]

@Steven19

Can you give us a 4 -5 line overview of your "Document Control" application?

Just want get some idea of:
-the kinds of documents involved
-the number of users
-the permissions of the users(add,modify, delete, ReadOnly...)
-the volumes
-the types of access (queries, reports)