Determine Which form opened another one.

[James79]

I want to be able to determine which form has opened another one. For example, if you have a calendar form with a simple calendar control in it, and this is opened from 5 different locations. When the calendar is closed it is meant to insert the date into the form that opened it. How can I tell in code which form opened the calendar. Is there another way besides global variables, or the .isloaded property of a form.

 

[Lightning]

In the module of the second form, set up a variable and pass the name of the calling form to the variable. Set this variable in the On Open event of the form.

When closing the second form (Or whenever you need to update the original form), use the variable value to update the correct form.

HTH

Lightning

 

[jebry]

Hi!

Use the OpenArgs in the OpenForm method:

DoCmd.OpenForm "YourCalendarForm", , , , , , Me.Name

This will pass the form name to the calendar form and you can reference the name passed in the calendar form using Me.OpenArgs.

hth Jeff Bridgham
bridgham@purdue.edu