If And Statement

You need to use And, not &

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


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Pam" wrote in message
...
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

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

I still can't get it to work as needed. If Tech has time running on job and
starts another job, WorkLogReminder should pop-up with open time based on
null stop time and tech name on WorkLogHiddenOpen. Sometimes it will pop-up
and others it will go right to the GenInfo form with the subform for time
entry. The subform for time entry and the hidden open form are both based
on the same query. I thought maybe it was an update (requery) issue, but I
just closed the db with null stop time and went back in and it went straight
to the time entry form - not catching that there was time running on another
job.

Do you have any suggestions to what I might be doing wrong?
Thanks for your help.
Pam



"Douglas J. Steele" wrote in message
...
You need to use And, not &

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


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Pam" wrote in message
...
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

Are you certain that Forms!fttWorkLogHiddenOpen!CboTech equals
Forms!fttswitchboard!CboTech?

With the form open, if you go to the Immediate Window (Ctrl-G), what values
do you see?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Pam" wrote in message
...
I still can't get it to work as needed. If Tech has time running on job
and starts another job, WorkLogReminder should pop-up with open time based
on null stop time and tech name on WorkLogHiddenOpen. Sometimes it will
pop-up and others it will go right to the GenInfo form with the subform for
time entry. The subform for time entry and the hidden open form are both
based on the same query. I thought maybe it was an update (requery) issue,
but I just closed the db with null stop time and went back in and it went
straight to the time entry form - not catching that there was time running
on another job.

Do you have any suggestions to what I might be doing wrong?
Thanks for your help.
Pam



"Douglas J. Steele" wrote in message
...
You need to use And, not &

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


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Pam" wrote in message
...
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

I have the immediate window at the vba code screen and both switchboard and
workloghiddenopen are open, but there is nothing in the immediate window. I
selected a tech and still nothing.


"Douglas J. Steele" wrote in message
...
Are you certain that Forms!fttWorkLogHiddenOpen!CboTech equals
Forms!fttswitchboard!CboTech?

With the form open, if you go to the Immediate Window (Ctrl-G), what
values do you see?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Pam" wrote in message
...
I still can't get it to work as needed. If Tech has time running on job
and starts another job, WorkLogReminder should pop-up with open time based
on null stop time and tech name on WorkLogHiddenOpen. Sometimes it will
pop-up and others it will go right to the GenInfo form with the subform
for time entry. The subform for time entry and the hidden open form are
both based on the same query. I thought maybe it was an update (requery)
issue, but I just closed the db with null stop time and went back in and
it went straight to the time entry form - not catching that there was time
running on another job.

Do you have any suggestions to what I might be doing wrong?
Thanks for your help.
Pam



"Douglas J. Steele" wrote in message
...
You need to use And, not &

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


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Pam" wrote in message
...
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

If I remove the line of code Forms!fttWorkLogHiddenOpen!CboTech equals
Forms!fttswitchboard!CboTech and I have two techs (TechA & TechB) with time
running...

I can select TechA and a job for TechA and the reminder opens to TechA's
name and running time. I can close the reminder form without entering stop
time for TechA.

I can select TechB and a job for TechB and the reminder opens to TechB's
name and running time. I can enter stop time for TechB, go back to
switchboard and select TechB and a job and it will go to the time entry
form. This is correct.

But, now when I go to TechA who still has running time, it goes straight to
the time entry form.

I have went round and round with this and it is very frustrating. I know I
have something set up wrong but I can't figure out what it is.

Pam


"Douglas J. Steele" wrote in message
...
Are you certain that Forms!fttWorkLogHiddenOpen!CboTech equals
Forms!fttswitchboard!CboTech?

With the form open, if you go to the Immediate Window (Ctrl-G), what
values do you see?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Pam" wrote in message
...
I still can't get it to work as needed. If Tech has time running on job
and starts another job, WorkLogReminder should pop-up with open time based
on null stop time and tech name on WorkLogHiddenOpen. Sometimes it will
pop-up and others it will go right to the GenInfo form with the subform
for time entry. The subform for time entry and the hidden open form are
both based on the same query. I thought maybe it was an update (requery)
issue, but I just closed the db with null stop time and went back in and
it went straight to the time entry form - not catching that there was time
running on another job.

Do you have any suggestions to what I might be doing wrong?
Thanks for your help.
Pam



"Douglas J. Steele" wrote in message
...
You need to use And, not &

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


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Pam" wrote in message
...
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