Copying date from one text form field to another?

[plpl78]

Sorry if this has been answered somewhere else.

I have a one page word 2007 file. The file has text boxes all over it and inside those text boxes i have text form fields.

I have been trying for days to link some of the text form fields so that when a user types data in one of the text form fields it copies it to another text form field.

As an example.

The first text from field is where i want the person to enter there date of birth. The name of this text form field when you go into its properties is DOB.

I have two other text from fields that are in text boxes where i want the info from DOB to be copied once the user types in there date of birth.

Will anyone please help me with this? It's driving me NUTS!

 

[littleiitin]

Let say other two textbox names are DOB1 and DOB2 then

Private Sub dob_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
    DOB1.Text = dob.Text
    DOB2.Text = dob.Text
End Sub

 

[Macropod]

Hi plpl78,

First, set the 'DOB' formfield's 'calculate on exit' property.
Second, delete the dependant formfield.
Third, insert a cross-reference where the deleted formfield was, pointing to the 'DOB' bookmark.
Repeat as necessary for the same/other formfield references.
Protect your form and off you go. No vba required!

littleiitin: Your solution is not applicable to formfields - it applies only to textboxes on a useform.

 

[littleiitin]

Thanks Macropod,

I did not see that plpl78 used Word 2007. I thought it is in Excel user forms and he is writing Text boxes as Form fields. Thanks for information.

 

[plpl78]

Hi plpl78,

First, set the 'DOB' formfield's 'calculate on exit' property.
Second, delete the dependant formfield.
Third, insert a cross-reference where the deleted formfield was, pointing to the 'DOB' bookmark.
Repeat as necessary for the same/other formfield references.
Protect your form and off you go. No vba required!

littleiitin: Your solution is not applicable to formfields - it applies only to textboxes on a useform.

I'm sorry i had some of my info wrong. It's a table there are no text boxes at all. All of the data is typed into the table.

The table has a total of 20 different sections. I have text form fields in some of the sections.

Also when a user opens the form, they are only able to fill out the text form fields and nothing else. Once the form is filled out they print it and close the form. The form they fill out they do not save.

So how would i go about it now that we know its a table?

Thanks again for all your help guys

 

[Macropod]

I'm sorry i had some of my info wrong. It's a table there are no text boxes at all. All of the data is typed into the table.

The table has a total of 20 different sections. I have text form fields in some of the sections.

Also when a user opens the form, they are only able to fill out the text form fields and nothing else. Once the form is filled out they print it and close the form. The form they fill out they do not save.

So how would i go about it now that we know its a table?

Thanks again for all your help guys

Whether you're using textboxes makes no difference. Provided you have a 'DOB' formfield, the solution remains the same.