Argument not optional and run time error 424

[joym]

I created the 2 codes below both worked while i directly wrote in as the control source in design view however when did this as an on click event i am having issues

This code gets an error argument not optional

Private Sub txtDSE_Click()
Me.txtDSE = IIf([Resolution Date And Time] > [txtRTF], Diff2Dates("ymdhn", [txtRTF], [Resolution Date And Time]))
End If
End Sub

This code gets a run time error 424

Private Sub txtSS_Click()
Me.txtSS = IIf([txtDSE] Is Null, "Within SLA", "SLA Exceeded")
End Sub

[ranman256]

IIF has the arguments: IIF(condition, TrueResult, FalseResult)

you left off the false
IIf([Resolution Date And Time] > [txtRTF],
Diff2Dates("ymdhn", [txtRTF], [Resolution Date And Time])
, falseValue)

and you dont need ENDIF. IIF is selfcontained.

[Bulzie]

1. First line, Is txtRTF a date value?
2. What are you trying to do here: Diff2Dates("ymdhn", [txtRTF]

3. Second line maybe, IIf(Isnull([txtDSE]), "Within SLA", "SLA Exceeded")

[joym]

thanks worked like a charm

[joym]

1. First line, Is txtRTF a date value?
2. What are you trying to do here: Diff2Dates("ymdhn", [txtRTF]

The diff2date is a module I created that subtracts time and displays the difference

3. Second line maybe, IIf(Isnull([txtDSE]), "Within SLA", "SLA Exceeded")

this partially worked however it only displays SLA Exceeded even if txtDSE is empty

[Micron]

To avoid the possibility that Access considers the control reference to be ambiguous, use the full control reference:
IIf(Isnull(Me![txtDSE]), "Within SLA", "SLA Exceeded")
If you're allowing and have empty strings in the table field, you'll have to test for both Null and zero length strings but I'm not sure what you mean by empty. Empty has a specific meaning that applies to a declared object variable that contains no object.
You might need to have a function as the control source, but IIRC, you cannot do this if the control is bound

If IsNull(Me!txtDSE) Then
  something = "Within SLA"
Else
  somethingElse = "SLA Exceeded"
End If

I guess you could do a nested IIF to test for both, but I try to avoid those as much as possible.

The reason for the error before is that Is Null is for queries; IsNull() is a vba function.