update form field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a field called "Status". I would like an another field on
the form called "Last Update" to be updated with the current date and time
whenever the value in "Status" field is changed. Both field are linked to an
underlying table.

Thanks!
 
Warning change the name of "last update" to last_update or lastupdate or
something similar as last and update are reserved words in access. I think
status is also a reserved word.

In the AfterUpdate event ofn the field "Status" enter the following

me!last_update = now()
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
Query design 0
iif exists - too complex? 1
Access Validation rule in MS access 2010 1
Restrict data in one field based on content of another 2
Copy record info into new form 0
Access Form - Lock Fields from Editing 0
copy a field in a form 2

Back
Top