how to give a textbox value taken from calling form

[maher habaj]

I have a form containing a command button which calls another form and I want to put in the last opened form a value taken from the calling form

[patjones]

You're not giving us very many details to go on. I can only give you a couple of general concepts to consider.

First is the OpenArgs argument of DoCmd.OpenForm. This allows you to pass a value into the form that you are opening. It is well documented in the Access help pages and elsewhere.

Second is the possibility of setting up a global variable that you can assign your value to, and which any form in your project will be able to see.

Good luck.

Pat

[NeoPa]

There are two basic methods, each of which will work :

1. Pass the value required in the OpenArgs parameter and handle this in your opened form's Form_Open() procedure.
2. Open the second form then, in the code after the call to open, set the value of the control in the opened form.