Access 2016 VBA Syntax Error

I'm getting the following syntax error

IIF(Me.Call_Date < 3/8/2018 Then
Me.Call_End_Time IsNull
ElseIf
Me.Call_End_Time = Format(Now, "hh:nn:ss"))
End If

Open in new window

shieldscoAsked:
Who is Participating?
 
Dale FyeCommented:
In VBA Code this would look like:

IF Me.Call_Date < #3/8/2018# Then
    Me.Call_End_Time = NULL
Else
    Me.Call_End_Time = Format(Now, "hh:nn:ss")
End If

Open in new window

OR
me.Call_End_Time = IIF(Me.Call_Date < #3/8/2018#, NULL, Format(Now, "hh:nn:ss"))

Open in new window

0
 
shieldscoAuthor Commented:
Thanks
0
 
Dale FyeCommented:
glad to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.