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