How to pass value from one table to another one

[hapm]

As already mentioned BrowseTo invalidates the object referenced by Me, because the form is closed after executing the BrowseTo. As the code runs to it's end, you can store the value of Me.TextBox in a local variable, do the BrowseTo and apply the value from the local variable to the text box of the new form that was just opened by BrowseTo. You can add a Public Property to your form as well and use the put sub to react on a change of the value from outside of the form.

[ItsMe]

...As the code runs to it's end, you can store the value of Me.TextBox in a local variable, do the BrowseTo and apply the value from the local variable to the text box of the new form that was just opened by BrowseTo....

I do not understand this as being possible.

[June7]

ItsMe is correct about global variables losing their value during a run-time error. That's where TempVars are supposed to have an advantage.

[hapm]

I do not understand this as being possible.

Dim tmp
tmp = me.TextBox
DoCmd.BrowseTo ...
Forms![New Contact].[IDFieldName].Value = tmp

Well, you will need to fix the reference to the control as it is in a subform.

[June7]

hapm, I think the issue with local variable and Navigation form is the form with the local variable is closed by BrowseTo before the variable can be used to populate the second form, hence the need for global variable.

[hapm]

The funny thing here is that the code runs to its end, even so the form is already cleaned up. The only thing you can't do is using Me after the BrowseTo, as the referenced object behind this variable is marked as closed (even so it still exists until the code has finished of and all dereferenced objects get cleaned from memory.

[June7]

Ooops, yes, of course, the first form code is pushing value to the second form. I do that with normal forms (guess I had wires crossed with referencing the control after form is closed which would fail but setting variable retains the value until code finishes). Don't see why navigation form should be different.

[ItsMe]

That's pretty cool. I have never tried anything like that before.