Getting Value from field in form, to another field in form

[Jarad]

This isnt exactly what it sounds like. I know I can control the input mask, and set it = to another field in a form, but the problem with that is then if you type over that field, it changes the other field in the form as well. I am wanting the 2 fields to be independant of each other, but IF one field has a value, the other field needs to have that value. If it is blank, the other field needs to be null.. example

Field A = 1

I Need field B to Also = 1. If Field A is blank, I need field B to be blank. The kicker. After Field B has Field A's value. I need to be able to update field B later, WITHOUT affecting Field A's value.

Any ideas??

 

[rainman89]

in the afterupdate of A's box use
me.b=me.a
this should change the value of b to A, but still allow b to be changed

 

[Jarad]

thanks, that got me in the right direction. I got it eventually, the problem was that the values on the form were coming from different tables in the database. That was the tricky part.

Thanks Again!!