By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,116 Members | 1,319 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,116 IT Pros & Developers. It's quick & easy.

undo for a form in datasheet view

P: 14
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
Oct 19 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Oct 20 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.