From: Pam on 19 Mar 2010 10:54
I'm having problem with the code below not going to the form as needed.
When CboTech (TechA) selects JobNumber from fttswitchboard and has time
running on another job and he is the tech on record 1 in the
fttWorkLogHiddenOpen form, then the fttWorkLogReminder form opens to his
If TechB selects a job from the switchboard and he has time running on
record 2 in the fttWorkLogHiddenOpen form then it bypasses the
fttWorkLogReminder form and opens the fGenInfoTT at the job number selected
and allows him to start another job in addition to the one he already has
If it makes a difference, both the hidden form and the reminder form work
from the same query.
If IsNull(Forms!fttWorkLogHiddenOpen!StopTime) And _
(Forms!fttWorkLogHiddenOpen!CboTech) = Forms!fttswitchboard!CboTech Then
DoCmd.OpenForm "fttWorkLogReminder", , , "tech='" &
Forms!fttswitchboard!CboTech & "'"
DoCmd.OpenForm "fGenInfoTT", , , "jobnumber=" & Me!JobNumber
I was thinking maybe I need to find the record that matches on the
fttWorkLogHiddenOpen form first before asking it to open the forms, but have
tried code form researched posts and can't seem to get anything to work.
I would greatly appreciate any help.
Thanks in advance,