Button to copy contents of one field into another field on the same form

[bluereef]

Hi



I am new to Access 2010 and still coming to terms with a lot of its functions etc.

However, I have created a database to store information about members of my local Kayaking club. This is fairly detailed and includes addresses and personal information.

One of the sections on the form is details on next of kin. In most instances the address fields for the next of kin are the same as those for the member himself. Rather than retyping the same information out again I want to put a control button next to each address field which - when pressed, takes the info from [Address 1] and sticks it in [NK-Address 1]. I thought this would be fairly simple but I am obviously doing something wrong.

Can anyone help - in terms that a beginner is going to understand. !!

Thanks

[RuralGuy]

Your button should have code similar to:
Me.[NK-Address 1] = Me.[Address 1]
...assuming those are the names of the two controls involved.

[bluereef]

Many thanks - seem to have solved the problem. Stangely it worked when I put the code directly into the page - but didn't work when I used the expression builder. Its probably me - still learning . . . thanks again.

[RuralGuy]

Great! Are you ready to use the Thread Tools and mark this thread as Solved?