If And Statement

From: "Pam" <pamnospam@xxxxxxxxxxxxxxxx>
Date: Thu, 11 Mar 2010 09:36:06 -0600

Hello,

Can someone please tell my why this code will not open the Reminder form
when StopTime is blank for the tech selected? It goes straight to the
GenInfo form.

If IsNull(Forms!fttWorkLogHiddenOpen!StopTime) & _
(Forms!fttWorkLogHiddenOpen!CboTech) = Forms!fttswitchboard!CboTech Then
DoCmd.OpenForm "fttWorkLogReminder", , , "tech='" &
Forms!fttswitchboard!CboTech & "'"
Else
DoCmd.OpenForm "fGenInfoTT", , , "jobnumber=" & Me!JobNumber
End If

Thanks in advance.
Pam

.

Follow-Ups:
- Re: If And Statement
  - From: Douglas J. Steele

Prev by Date: Re: If And Statement
Next by Date: Re: Filter Form doesn't close
Previous by thread: Form Width Grows
Next by thread: Re: If And Statement
Index(es):
- Date
- Thread