Using Global Var's to Ref Objects

[crose7227]

I have a problem where I want to be able to call a calendar control from any form and pass that forms name and the name of the text box to update with the calendar's value.

I have tried assigning the name of the form/textbox to globals. My problem is that I dont know the method to reference a form using a global variable... such as



Forms!varFormFrom.varTextBox.value = ActivexCtl0

this does not work...

Has anyone else ran into this problem? Long Live Motor

 

[jhall156]

In a module(global not object)
Global FormToUse As Form

In button OnClick of Form module of form where the date will end up

Set FormToUse = Me
DoCmd.OpenForm "YourCalendarForm"

In button OnClick of form module of YourCalendarForm

FormToUse.Controls("YourDateTextBox&quot.Value = Me.YourCalendarControl.Value
DoCmd.Close

JHall