else if statement

  • Thread starter Thread starter troy
  • Start date Start date
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
 
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
 
Back
Top