Information transfer

**tomclavil** · 02-06-2011, 01:01 AM

Hello,

I created an "Employees" table with many fields.
Based on the table and to ease data entering I created a form named "Employees". This form only includes few fields like name, employee number and address.
At the bottom of the form, I placed some buttons that open extra forms to continue completing data.
One of the extra forms is named "OJ" and depending on dates and names entered there, there is a test box that shows a message. For example "employee under training" or "employee on vacation". The information showed in the text box is not stored in any field. It just inform some situation.
What I´m trying to do is that the information showed in the text box in the form "OJ", also appears in the form "Employees"

The employees form is opened first and before any data is entered into "OJ" form, but after completing the "OJ" form I need the data appears in the employee form.

In the employee form I placed a text box with an expression on it, but doesn´t show the information ans states #error or #name....

the expression entered into the text box is =[forms]![OJ]![Text124]

Regards,
Claudio
Thanks for your help in advance!

**RuralGuy** · 02-06-2011, 06:30 AM

You should really name your controls something informative. Having said that, the "OJ" form needs to be open for your code to work. Is it?

**tomclavil** · 02-06-2011, 11:21 PM

Sorry but my understanding of access is very restricted. According your response, you mean that the OJ form needs to be open so the information can be transfered to the employee form?

Thanks for your help!
Claudio

**tomclavil** · 02-06-2011, 11:24 PM

Do you mean that the OJ form needs to be open, so the data can be transfered to the employee form?
Also, I have no idea of "code" and all that....where can I have more basic information to start understanding a bit more.

Thanks a lot!