update field

S

Squibbly

i have a macro that when you update any of the fields/control it then puts
the date and time when last updated. does anyone know how to tell which
field/control has been updated?
 
S

Steve Schapel

Squibbly,

I guess you would need to catch the After Update event of every bound
control on your form, and run an Update Query to a field which stores
the name of the changed field.
 

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

Clear a date field using a macro 12
update of field or control 2
If null then enter a value 2
Nexus 7 Update 3
SetValue Macro help 3
Word VBA to update cross-referencing 0
automatic update to a field (Date/Time) 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top