Dan Waters
dwaters at usinternet.com
Sun Oct 16 09:57:40 CDT 2005
I'm going to add a calendar button adjacent to each date field throughout many forms. The code, a public function procedure, will be in a standard module (in a library). Each calendar button will call the function procedure using a call from the OnClick event procedure of the button. The call in the event procedure is this: =CalendarButton("frmName","txtName",True) The function is this: Public Function CalendarButton(stgForm As String, stgDate As String, blnAfterUpdate as Boolean) Dim frm As Form Dim txtDate As TextBox Set frm = Forms(stgForm) Set txtDate = frm.Controls(stgDate) If txtDate.Enabled = False or txtDate.Locked = True Then Set frm = Nothing Set txtDate = Nothing Exit Function End If txtDate = PopupCalendar(txtDate) '--- Call back to the control's AfterUpdate event for validation If blnAfterUpdate = True Then Call frm.txtDate_AfterUpdate <------------ This line doesn't work. Call frm.txtCustomerDueDate_AfterUpdate <-- Works, but doesn't help. End If If Not IsNull(txtDate) Then SendKeys Chr(9) '-- Tab Key End If End Function I need to call the field's AfterUpdate procedure (which is now Public) to perform validation, which is different for different date fields. Is there a way to do this? Thanks! Dan