I have a Customer database which allows input of name and address details of the main contact and their partner.
On the form, when you get to the partners details, the address is often identical. Is there a way of having a default value being the main contacts address. If this is the case there may be occasions where this needs to be overwritten.
Alternatively, is there a command anyone has used which can fill a partners address details to be the same as the main contacts if required.
On the first option I have experimented with code on the field on the form (default value) without success:
= [CustomerMCStreet]
=Forms!frmCustomer!CustomerSCStreet.DefaultValue = Forms!frmCustomer!CustomerMCStreet
=[Forms]![frmCustomer]![CustomerSCStreet].[DefaultValue]=[Forms]![frmCustomer]![CustomerMCStreet]
The second option above would be a preferred option and easier for users.
Thank you.
On the form, when you get to the partners details, the address is often identical. Is there a way of having a default value being the main contacts address. If this is the case there may be occasions where this needs to be overwritten.
Alternatively, is there a command anyone has used which can fill a partners address details to be the same as the main contacts if required.
On the first option I have experimented with code on the field on the form (default value) without success:
= [CustomerMCStreet]
=Forms!frmCustomer!CustomerSCStreet.DefaultValue = Forms!frmCustomer!CustomerMCStreet
=[Forms]![frmCustomer]![CustomerSCStreet].[DefaultValue]=[Forms]![frmCustomer]![CustomerMCStreet]
The second option above would be a preferred option and easier for users.
Thank you.
