Set value of a control based on where the call came from

[jlindquist]

I have a form that holds a date submitted and a due date value on it. Next to each I have a button to pop up the same little calendar. Upon selection of a date I would like to set the value of the control where the original call came from.

Form Project
Date Submitted: (BUTTON)--> Pop open calendar
Due Date: (BUTTON)--> Pop open calendar

Upon selection of a date I want to do something like Forms![FORM]![CONTROL].value = Calendar.value where FORM and CONTROL are where the value should be put based on where it originally came from.

 

[Ziggurat]

If you using only a single form then all you need to do is to send the control name of the date field to the calendar form using OpenArg

for example when you open the form from the button use the command
docmd.OpenForm "frmCalendar",,,,,,"DueDate"
(OpenArg is the 7th Parameter)
Where DueDate is the name of your control

then on your calendar form use the command
Forms!<Your Form Name>.controls(me.openArg)= Calendar.value

HTH

*
***
*****
*******
Ziggurat

 

[jlindquist]

Works like a charm. Thank you!