Passing a value from a form to another form

[AT76]

Hi all,

Is there a way to pass a value from a form to another form?

Or, how would you access a form from another form?

Thanks!!!

Here's what I have:

Me!Dest1!Dest1FieldName = Forms!Source!Source1FieldName

 

[PHV]

And what's wrong with what you have, provided Source is an open mainform ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AT76]

Yes, Source is open. Destination is actually a subform.

I'm trying this but not working:

Me!Me_Selector!Add_Lesson_To_Course = Forms!frm_PopupNewLesson!Lesson_Name

Me!Dest1MainForm!Dest1SubForm.Dest1SubFormFieldName= Forms!Source!Source1FieldName

but it tells me it doesn't recognize the mainform. Any idea?

Thanks!

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

In which form is located your code ? ie what is Me in your code ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AT76]

It's in: frm_PopupNewLesson

 

[AT76]

I figured it out, I the form there was another level of subform. Thanks PHV!