transfer data between forms

How can I move data between forms, even I used Public Variable and Function
Thanks.

What's wrong with public? Did you try it?

My personal preference would be to use a custom form property. You can create properties in forms just as you would in a class module. The main benefit here is that the forms remain self-contained and you don't need a separate module to hold public variables.

The properties are accessed the same way as for normal form properties, eg

VB Code:

frmMain.MyProperty = strWhatever

Oh, and by the way, you can reference a form's custom property with needing to have the form loaded and accessing the property will NOT cause the form to load.

Very useful IMHO.