Check box - "Same as billing address"

[brettnolan]

I have a form asking for a billing address and a service address. Many times these will be the same. I added a check box to check to populate the following fields; Service Address, Service City, Service State, Service Zip.

Fields that it will be coming from are the same, just named Billing instead of service. Tried expression builder and macro builder with no luck. I know this is simple.

Thanks again in advance,
brettnolan

[brettnolan]

While I'm here asking a stupid question...how about a quick sub procedure to clear all fields when I open the form?

thanks

[June7]

I don't use macros, only VBA. Is this form in single or continuous view? Is the checkbox bound or unbound? Code in checkbox Click event:

If Me.checkboxname = True Then
Me.[Service Address] = Me.[Billing Address]
Me.[Service City] = Me.[Billing City]
Me.[Service State] = Me.[Billing State]
Me.[Service Zip] = Me.[Billing Zip]
Else
Me.[Service Address] = Null
Me.[Service City] = Null
Me.[Service State] = Null
Me.[Service Zip] = Null
End If

What do you mean by 'clear the fields'? Is this form bound to table/query? Then what you need is move to new record or open the form in DataEntry only mode.