else if statement

[troy]

Is something like this possible? It's not working the way I have it now.

ElseIf IsNull(Me.txtFindOfficer) And (Me.txtFind) <> Null Then

'do cmd if txtfindofficer is empty and txtfind contains data

end if

 

[tina]

well hopefully you've only posted the "middle and end" part of the If
statement, because you must start the statement with If...Then before you
add an ElseIf clause. as for the conditions, try

ElseIf IsNull(Me.txtFindOfficer) And Not IsNull(Me.txtFind) Then

hth