else if statement

T

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
 
T

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
 
Top