Copying from 1 Textbox to another Textbox on different Forms

[Crackers]

I have a text box on 'Forma' & a textbox (named text3) on 'Formb'.
I want to copy the contents of the textbox from 'Formb' to the textbox on 'Forma'. I have used the following code in the textbox on 'Forma'....

=Forms![Formb]![Text3].text

This doesn't seem to be working whether both Forms are open or only 'Forma'. Could somebody please advise as to what I am missing. Your assistance is very much appreciated.

 

[ansentry]

What is the name of the text box on FormA?

When the data is copied to FormB, which record does it copy it to?

If you just open formB and copy the data to text3 it will always copy to the first record unless you set up some Criteria in your code.

I know it is none of my business but why would you want another copy of data that you already have in a table.

If you post back the answers I will post some code for you.

 

[Crackers]

re: Text box copying

The 1st Form is "Form1" with the name of the Textbox being 'text73" & the second form is "Form2".
On the 2nd form I have a whole lot of criteria that when answered by an operative, will fill in the text box on that form. The text box on the 1st form is to collate this information along with information on the first form. There are no queries or tables relating to the form as it is just a questionnaire that needs to be filled out. When the text box on Form 1 has all the information in it, I then need to paste this information into a stand alone program that does not work with Access.
I hope I have explained it okay.

 

[ansentry]

Crackers,

Sorry but I am more confused after reading you last post, in the first post you say that you want to copy from formA to FormB. Now you say that you want to put an amount of data in a text box and then paste it to a stand alone progam.

Can you export the data from access to the "stand alone program", like exporting from access to excel?

 

[Crackers]

re: Text box copying - Take 2

Sorry for the confusion.
On Form2 I have a text box that contains formulas which populate the text box from the answers given on the questionaire on Form2. eg: IIf([Option1]=Yes,[Text44],""). Now when the Form2 has been completed, the answers that are in the Text Box need to be copied onto a text box on Form1 because the text box on Form1 already contains data taken from Form1. The contents of the text box on Form2 need to follow on underneath the text from Form1.
The program that the information will be pasted to is not a compatible program with any of the Microsoft programs. It is a business program designed specifically for my line of work.