Prev: Designing forms
Next: Synchronize Form and Subforms. Second Subform is the problem.
From: Pam on 11 Mar 2010 16:17
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" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message
news:uoS0g3UwKHA.3564(a)TK2MSFTNGP05.phx.gbl...
> 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" <pamnospam(a)deltaprocess.com> wrote in message
> news:uf$XF3TwKHA.4908(a)TK2MSFTNGP06.phx.gbl...
>>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" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message
>> news:On65y8SwKHA.5036(a)TK2MSFTNGP02.phx.gbl...
>>> 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" <pamnospam(a)deltaprocess.com> wrote in message
>>> news:OSfNz2SwKHA.4636(a)TK2MSFTNGP06.phx.gbl...
>>>> 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
>>>>
>>>
>>>
>>
>>
>
>


First  |  Prev  | 
Pages: 1 2
Prev: Designing forms
Next: Synchronize Form and Subforms. Second Subform is the problem.