Replace Data from One Field to Another

[Sander]

It has been quite a while since I've developed a database and I am drawing a blank on how to do this.....

I have a form where if the user enters information in one field it will automatically take that information and update (techincally it will replace the data) another field on the same form. I am assuming that I want to do this on the OnChange event but I am at a loss on how to code it. It is makes a difference, I need to do this twice - once with text and once with dates.

If anyone has any ideas I would appreciate it.

Thanks!

 

[RuralGuy]

Use the AfterUpdate event of each control and simply put:
Me.OtherControlname = Me.ThisControlName
...using your control names of course.

 

[DannySeager]

why doesn't the user update the 2nd field directly?

 

[RuralGuy]

You wouldn't be storing calculated values would you? That would be a no..no.

 

[Sander]

DannySeager - the truth is I don't know. I've been saying the same thing. But what you're saying is true. THe two fields are exactly alike, the customer just wants it moved futher up above on the form. I could see if they want to keep a history of some sort one would keep the last and the other would keep changing but from what I've been told - no history.

RuralGuy - Thanks for the info. And nope, I'm not updating, just taking a name in one case and a date in another and moving it further up on the form.