I have a form that I want to return a date value - basically it is a calendar control that I can use throughout my app. I want to create a function that opens the form, potentially passing it a date, opening the form, and then, when another date or cancel is clicked, closes the form, returns to the calling function, and sets the value in the designated control.
Function GetCalValue(optional inDt as date)
If IsNull(inDt) then
inDt - Date()
' open the form here and return the value from the form???
GetCalValue = 'open form modal and return value based on user selection
I am missing something obvious?