Save record before it is changed.

[raghuprabhu]

Hi All,

I want to save a copy of the record in the main form. If some one changes the record in the main form, how do I save it?

Generally if a female person gets married her title changes from "Miss" to "Mrs" and her surname changes too.

So in this sample database I have tried to save the record on changing of two fields, title and / or surname. It is not working. What am I doing wrong? The record is being saved after the change and not before.

Thanks

Raghu

 

[dnesci]

Raghu,

When you are using the Title for example in your insert, you are using the text from the screen in your insert. This text is already changed. In you before update event you could use Title.OldValue. The oldvalue property has the value currenly in the record in the database. This will insert a record with the correct old title.

Don

 

[raghuprabhu]

Thanks. Will try that.