how to copy access values across different fields

[mkrinke]

I have a table with 3 fields, fld1, fld2 and fld3. If any of the fields has a value, I want to copy that value into all 3 fields. Even if 2 or more fields has a different value, I want to take any one of the values and populate all 3. Any suggestions on a good way to do this?

 

[Remou]

How about setting the value of two fields in the AfterUpdate event of the third.

Me.TextB=Me.TextA
Me.TextC=Me.TextA

And so on.

 

[PHV]

What is the purpose of having 3 fields with same value ?
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mkrinke]

Not my table, I just have to deal with adding data to it.

 

[TheAceMan1]

How are ya mkrinke . . .

For me, the redundant data caused me to shudder.

In any case [blue]Remou[/blue] has you in tow, only I would state it differently:

[blue]In the [purple]AfterUpdate[/purple] event of each control, update the other two.[/blue]

[blue]GoodLuck with this! . . . gonna need it! . . .[/blue]

See Ya! . . . . . .