I have two forms. FormA contains several dropdowns and a cmd to open a popup form (FormB) that contains a calendar. I created a module called modGlobalVariables (from post from Chris RR)in it I have Public CalSelDate.
Within a cmd button on FormB I then set CalSelDate = Me.ActiveXCal1. Then closed FormB (the variable is now held in CalSelDate). I now need to populate a text box with that value. But I can't think of another way to do this without creating another button to put the event in. Is there a way to close FormB and pass CalSelDate to a text box in one fail swoop?
Thanks in advance for any help rendered!!
Lee
Within a cmd button on FormB I then set CalSelDate = Me.ActiveXCal1. Then closed FormB (the variable is now held in CalSelDate). I now need to populate a text box with that value. But I can't think of another way to do this without creating another button to put the event in. Is there a way to close FormB and pass CalSelDate to a text box in one fail swoop?
Thanks in advance for any help rendered!!
Lee