Solved "You Called This Sub" (1 Viewer)

[Eljefegeneo]

I wrote the following code for my Access 2010 program:and it worked like a charm.

Dim DayVal As Long
DayVal = Weekday(Date, 1) 'Set first Day of Week, in this case Sunday.
If (DayVal = 6 And Hour(Now) > 15) Then
Call cmdZipAndEmail_Click
End

And when I transferred it to Access 2019 I get the following pop-up message box:

"You called this sub"

Don't want this - what is going on and how do I get rid of it?

 

[theDBguy]

Hi. Which line is highlighted when you go to debug?

 

[June7]

How could that code work? There is no End If line. If you don't want End If then put the Call line on same line as If Then.

 

[Eljefegeneo]

OK, it should have read the last line End if.

And the code is not highlighted, the message box just pops up.

 

[Eljefegeneo]

some Days I am just brain dead. Sorry for the post. Figured it out. I had inavertantly left in some code that triggered an error message that set off this pop up. Shame on me.

 

[theDBguy]

some Days I am just brain dead. Sorry for the post. Figured it out. I had inavertantly left in some code that triggered an error message that set off this pop up. Shame on me.

Hi. Glad to hear you got it sorted out. Good luck!