How do I get value what data has changed in my form.

  • Thread starter Thread starter KRISH
  • Start date Start date
K

KRISH

Hi Any body help me in solving the problem below:

I would like to track what chages made in editing a
record. I need both old and new values. The code should
automatically take what fields i am having in the table
set in the control source.

krish
 
What do you want to do with this data? How do you want the output
formatted? How many fields do you have? What are their names? Give us
more details.

You can get a field's oldvalue and new value using...

Me.SomeControlName.value

or

Me. SomeControlName.oldvalue



Rick B
 
I don't think MS Access has transaction tracking, which is what you're
looking for, I think. If you really need it to do that, you might need
to switch to SQL Server. Or you could just use another record, and keep
the old values in the old one.

grep
 
Back
Top