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

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

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


PEB
Expert 100+
P: 1,418
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
Oct 8 '06 #2

P: 14
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
Oct 11 '06 #3

Post your reply

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