To fields equal each other

[dmaranan]

I hope that this is an easy question:

I have two fields that need to equal each other, i.e. once the data changes in one, the other field needs to also change. (You may ask why not combine the fields; I have no answer.)

Thanks for your help.

 

[FancyPrairie]

2 ways to do it:

1. If the user always edits only 1 of the fields, then set the control source property of the 2nd field equal to the first field (i.e. =Text1)

2. In the afterupdate event of each of the fields, set the other equal to the current field.

 

[dmaranan]

I tried option 1, and it doesn't work. When I look at the table the field is blank for one of the fields.

How do I do opption 2?

 

[FancyPrairie]

Are you doing this via a form or what?

 

[dmaranan]

I'm doing this through a form. I'm just not sure what to put in the field for event/ afterupdate.

 

[FancyPrairie]

Assume that one field is named Text1 and the second field is named Text2. In the afterUpdate event of Text1, do this:

Text2 = Text1

In the afterUpdate event of Text2, do this:

Text1 = Text2

Now, if the user can only enter data into Text1, then no need for an afterUpdate event for Text2.