help with auto fill

[riddicule123]

hi i need help auto filling one text box with the same details from another using a check box.

i have two columns of text boxes on a form. one with the following, address line 1, address line 2, address line 3, address line 4 and postcode. and the other is installation address 1, installation address 2, installation address 3 installation address 4 and installation post code. what i want is that if both of these addresses are the same then the user can just fill in the address lines 1-4 postcode and then tick a check box and all the instakllation address text boxes fill with the same data. now i thought of using the below code:

Private Sub Check65_Click()
Me.Address_Line_1 = Me.Installation_Address_1
Me.Address_Line_2 = Me.Installation_Address_2
Me.Address_Line_3 = Me.Installation_Address_3
Me.Address_line_4 = Me.Installation_Address_4
Me.Post_code = Me.Installation_Postcode
End Sub

but it doesnt work.

each text box corresponds with a field in the table named Mail Merge. how can i get this code to work as it keeps telling me to fill address line 1 (address line 1 = null) problem comes up when i fill the boxes for a test run.

 

[vbaInet]

Me.Address_Line_1 = Me.Installation_Address_1

Left hand side receives, the right hand side gives. Makes sense?

You will also need to include an IF check there as well, but get the order right first.