Autopopulating a Form with Duplicate Info

[rowark]

I have a form with two fields, work_email and home_email. If after entering work_email, I would like to click on a check box if the home_email field is going to be the same information and have it copy what I entered in work_email into home_email.


Please help!

 

[Brian1960]

In the event of the tick box. On_Change
have this
If Me.TickBox = 0 then
Me.Home_Email = "" ' set it to blank if unticked
Else
Me.Home_Email = Me.Work_Email ' set it to Work
End if
Me.Refresh