Textbox events

[ItIsHardToProgram]

I was wondering what was the correct syntax to get a value from a textbox, from a form to another, having that other form closed, or if not possible, having it opened.... for example, On click, open a form, on that form, certain value are automatically entered depending on values entered on other form, and vice versa, on close, write down values from the closing form to the one opened....

Thanks in advance for your help!

 

[PHV]

One way:
Forms("name of open mainform").Controls("name of textbox").Value

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ItIsHardToProgram]

Putting the code on form load, I get an error msg saying the linking key is unavailable..... Does that mean I have to put a txtbox including that key on both forms?
If so, is there a more efficient way of doing it?

Thanks

 

[ItIsHardToProgram]

Scratch that, I had relations messed up, but My value is a date, and apparantly access dosnt allow to transmit the date as a value, so what should be written instead... ?

Thanks in advance

 

[ItIsHardToProgram]

Sorry for all my useless questions now, that problem is fixed, but i get a blank form on load, Its probably stupid so I won't waste your time and try to figure it out by myself, thanks for your help PHV.