I'm creating a small database which holds information about Grants. I have built a form and created reports which act as confirmation letters.
The Reports use Communication fields as their address.
I would like to populate the Communication fields with data already on the form in other fields when the button is pressed.
Commication fields //// Proposed Matched fields
Communication_Name ///// Applicant_Name
Communication_Address1 ///// Property_Address1
Communication_Address2 ///// Property_Address2
Communication_Address3 ///// Property_Address3
Communication_Address4 ///// Property_Address4
Communication_Address5 ///// Property_Address5
I had tried making these a default in the AfterUpdate event e.g.
If IsNull(me!Communication_Name) then me!Communication_Name = me!Applicant_Name
But this left the Communication_Name field blank - I'm not sure why?
I would prefer to use a Button control rather than set the default - can anyone help?
Thanks
Suze
The Reports use Communication fields as their address.
I would like to populate the Communication fields with data already on the form in other fields when the button is pressed.
Commication fields //// Proposed Matched fields
Communication_Name ///// Applicant_Name
Communication_Address1 ///// Property_Address1
Communication_Address2 ///// Property_Address2
Communication_Address3 ///// Property_Address3
Communication_Address4 ///// Property_Address4
Communication_Address5 ///// Property_Address5
I had tried making these a default in the AfterUpdate event e.g.
If IsNull(me!Communication_Name) then me!Communication_Name = me!Applicant_Name
But this left the Communication_Name field blank - I'm not sure why?

I would prefer to use a Button control rather than set the default - can anyone help?
Thanks
Suze