Hi,
I'm trying to create in VB Code where a subform is set 'Visible' = False and at a specific time change that 'Visible' setting to True. Here is what I wrote but it doesn't seem to work. I've put this VB Code in the "On Open" Event Action of the main form.
Private Sub Form_Open(Cancel As Integer)
Dim MsgTime
MsgTime = Time
DoCmd.RunMacro "mcrUpdateNOC"
DoCmd.Maximize
If (MsgTime = #2:40:00 PM#) Then
Me!frmExitMsg.Visible = True
End If
End Sub
Thanks in advance!
I'm trying to create in VB Code where a subform is set 'Visible' = False and at a specific time change that 'Visible' setting to True. Here is what I wrote but it doesn't seem to work. I've put this VB Code in the "On Open" Event Action of the main form.
Private Sub Form_Open(Cancel As Integer)
Dim MsgTime
MsgTime = Time
DoCmd.RunMacro "mcrUpdateNOC"
DoCmd.Maximize
If (MsgTime = #2:40:00 PM#) Then
Me!frmExitMsg.Visible = True
End If
End Sub
Thanks in advance!