add last_updated_by and last_updated_date in form

[akika]

hi
in access2016 form, i have 5fields (name, address, phone, email and comments) that read from table tbl_customer
how can i add the
last_updated_by (user that has login) and last_updated_date (date/time)fields.

 

[theDBguy]

Are those two fields available from the same table where your other fields on the form are coming from? If so, you can go to the form's design view, click on Field List button on the Ribbon and then should be able to drag the fields you want to add from the list on to the form.

 

[akika]

Thanks the last modified user & date is working.
along with the last modified, how can i add another field "Nf form data changed"
that get incremented each time that a change is done to that form?

 

[theDBguy]

Thanks the last modified user & date is working.
along with the last modified, how can i add another field "Nf form data changed"
that get incremented each time that a change is done to that form?

That request might require a little bit more clarification. What's considered as a change to count as 1? Otherwise, if you're simply trying to increment a counter each time both the modified by and modified date are updated, then simply add a 1 to the existing value in the field. For example:

Me.CounterFieldName = Me.ConterFieldName + 1

Hope it helps...