Copy from field to filed on a form (1 Viewer)

[johannaellamay]

Hi! I have a table and form for employees. I have two address, one is current, and the other one is permanent. On my form, I want to have a checkbox that says "Current address is the same as permanent address." By clicking that, I want to copy the data on the current address field to the permanent address field. I have looked online for solutions and found this code:

Private Sub check_EmployeeAddress_Click()

Me.eCurrentAddress1 = Me.ePermanentAddress1

End Sub

But everytime I run my form and click the checkbox, it just deletes the data on current address and does nothing on my form.

Help please?

 

[sparc]

Try me.permanentaddress1 = me.currentaddress1
you copy vice versa from empty field to the filled field

 

[johannaellamay]

Oh my gosh a million thanks! That was so simple it's embarrassing. Hahaha! Again, thank you.

 

[johannaellamay]

Okay now I have another problem. So I already know how to copy the data. But how do I reverse it? For example the user made a mistake and wants to just delete permanent address. So he/she could unclick the checkbox to do that. But how do I write the code?

 

[sparc]

Private Sub check_EmployeeAddress_Click()

if me.check_EmployeeAddress then
Me.eCurrentAddress1 = Me.ePermanentAddress1
else
Me.ePermanentAddress1 = ""
end if

End Sub

 

[johannaellamay]

private sub check_employeeaddress_click()

if me.check_employeeaddress then
me.ecurrentaddress1 = me.epermanentaddress1
else
me.epermanentaddress1 = ""
end if

end sub

thank you!