undo for a form in datasheet view

[lmawler]

Hi,

I have a list of offices that I've put in a form in datasheet view (so all the records show at once).

I want my users to be able to update the list, and then when they click a button, it will search through all my records and update the offices everywhere they appear.

I did this with another form that was one record at a time view by storing the values that are loaded when the form opens or the record changes. But with this one, I'm not sure how to do that, since it's all the records at once.

I had a suggestion of Me("field").oldValue, but again, not sure how this would work with multiple records, AND not sure what oldValue this gives -- the one from load? the first change? 2nd change? etc.

Any ideas?

Thanks,
Lea Ann

[MMcCarthy]

Your problem is with your structural design.

If this is a list of offices that is referenced by other tables and limited to the values in this table then it should be a lookup list with a ID field primary key added

e.g.

ID Office
============
113 HQ
114 Boston
115 New York

Every table that referenced these offices would do so on the lookup list and store the ID field rather than any other field. Therefore any changes to any other field in this table would be updated automatically to the other tables because the ID wouldn't change.

Hi,

I have a list of offices that I've put in a form in datasheet view (so all the records show at once).

I want my users to be able to update the list, and then when they click a button, it will search through all my records and update the offices everywhere they appear.

I did this with another form that was one record at a time view by storing the values that are loaded when the form opens or the record changes. But with this one, I'm not sure how to do that, since it's all the records at once.

I had a suggestion of Me("field").oldValue, but again, not sure how this would work with multiple records, AND not sure what oldValue this gives -- the one from load? the first change? 2nd change? etc.

Any ideas?

Thanks,
Lea Ann