Syntax for If statement in After Update Event

  • Thread starter Thread starter Susan L
  • Start date Start date
S

Susan L

I currently have an After Update event that fills the subject line on a form
control.

Now I need to add another control [Partner] whose value, if filled, will be
incorporated into the subject line. If it is not filled, the value from
another control [State] will be incorporated. [State] will be the control
that is most often filled, so [Partner] will be the Else.

Here is the current code:

Me![Identifier] = [TicketNum] & " - " & [State] _
& " - " & [ReceivedDate] & " - " & [txtDescriptionText]

I have received errors on the syntax I tried and wonder if someone can help?
 
Susan -

Here is the if statement you need to start with:

If IsNull(Me.Partner) Then
Me![Identifier] = [TicketNum] & " - " & [State] _
& " - " & [ReceivedDate] & " - " & [txtDescriptionText] & Me.StateList &
" - " & Me.State
Else
Me![Identifier] = [TicketNum] & " - " & [State] _
& " - " & [ReceivedDate] & " - " & [txtDescriptionText] & Me.StateList &
" - " & Me.Partner
End If
 
Back
Top