Problems with form

[John Smith]

Hi!

I will try to explain my problem the best I can...!

I have 3 forms.

Form1, on print_Click, open another form (Form2).

Form3, on print_Click, open the same form (Form2).

I have built a report that refer to some data on "Form1" and I don't want to
copy each report and change to code to refer to "Form3"

I have trie using this : Global mg_FormName As String but it dosen't work
when I use this command line:

me.Testing = Forms!mg_FormName!Test

Any idea??? Is my problem clear enough?

Thanks

JS

 

[Rick B]

I could be mistaken, but it seems you tell us what your scenario is, but you
never tell us what is not working. Are you getting an error message? Do
the forms not open? Does the report not print? What's up?

Rick B

Hi!

I will try to explain my problem the best I can...!

I have 3 forms.

Form1, on print_Click, open another form (Form2).

Form3, on print_Click, open the same form (Form2).

I have built a report that refer to some data on "Form1" and I don't want to
copy each report and change to code to refer to "Form3"

I have trie using this : Global mg_FormName As String but it dosen't work
when I use this command line:

me.Testing = Forms!mg_FormName!Test

Any idea??? Is my problem clear enough?

Thanks

JS

 

[John Smith]

Sorry!!!

Error message: Could not find mg_FormName, invalid parameters???

Global mg_FormName as string

Me.Test = Forms!mg_FormName!Test