When I change one record, I want to change all like records

[lmawler]

Hi,

I have a form that allows users to view a record, and then make changes to any of the displayed fields. I am using forms!formname.recordsource = sqlStatement to populate the form up front, and as a result, as the user types changes, they change the database table (right?)

Now, I want a "propagate changes" button so that when they click the button, the code goes through and finds all the records in the database that match this one on several fields. (each of the fields displayed is editable, and also needs propagating, so I have a routine that goes through and checks which field(s) have been changed, and then I need to propagate the change to each.)

The question is this: Once my user has changed the field, I can't search on what it was to find the matches -- I want every record in the database that matches what that field *was* so I can update it.

I am thinking when I populate the form, I need to store a copy of the record, but I'm not sure how...

Thoughts?

Thanks,
Lea Ann

[PEB]

Hi Lea Ann,

There is a way to know the old value!

You need to use the Before Update Event procedure of your respective control!

There is possibility to stop the change and to get the oldata using the property

oldvalue

Me![Myfield].OldValue

Best regards!

Vladimir

[lmawler]

Thanks, Vladimir!

Lea Ann

Hi Lea Ann,

There is a way to know the old value!

You need to use the Before Update Event procedure of your respective control!

There is possibility to stop the change and to get the oldata using the property

oldvalue

Me![Myfield].OldValue

Best regards!

Vladimir