Passing value from one form to another

[load3d]

I want to pass a value from one subform to another I've been able to successfully do this in this past using the stlinkcriteria function. However, this has proven to be ineffective at times. Does anyone know of a different way to do this?

 

[TheAceMan1]

How are ya load3d . . .

Assuming both subforms are on the same mainform, it all depends on where the code is running (effects subform referencing).

The following example assumes you'll double-click a textbox on subform1 and transfer (copy) the data to a predefined textbox on subform2 (note SF stands for subform):

[blue]   Me.parent![SF2].Form![SF2TextboxName] = Me![SF1TextboxName][/blue]

[blue]Your thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[load3d]

Okay, that's a good start. Thanks. What if subform2 isn't open at the same time as subform1?

 

[TheAceMan1]

[blue]What if subform2 isn't open at the same time as subform1?[/blue]

For a mainform with subforms this is not a problem. All subforms open wether the recordsource returns records or not.

Your question relates more to [blue]two independent mainforms[/blue], each with subform. In this case ... [blue]Yes![/blue] ... both mainforms have to be open.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]