enter value from textbox on form into another form on close

[Fipp]

I have 2 forms open.
the first form which is open in the background is called "main"
The "main" form has a textbox called [formationid]

The second form which is open on top and visible is called "formation" it
also has a textbox called [formationid]

I am trying to get it so that when I look up the record in "formation" and
then close the form the value in [formationid] on the formation form is then
entered into the textbox [formationid] in the "main" form.

 

[Dennis]

In the On close event of your formation form put this
[Forms]![Main]![formationid] = Me.formationid

 

[Fipp]

Dennis,
Thanks that works great except when the [formationid] field on the main form
already has a value it won't override the previous value with the new one.

In the On close event of your formation form put this
[Forms]![Main]![formationid] = Me.formationid

I have 2 forms open.
the first form which is open in the background is called "main"
The "main" form has a textbox called [formationid]

The second form which is open on top and visible is called "formation" it
also has a textbox called [formationid]

I am trying to get it so that when I look up the record in "formation" and
then close the form the value in [formationid] on the formation form is then
entered into the textbox [formationid] in the "main" form.