Prev: Clicking on Newly Opened Form
Next: text box help needed
From: Pam on 19 Mar 2010 14:35
Hi,

I keep getting the error 2427 no value message for the code below. I tried
adding a recordset.recordcount>0, but I don't think it is right. Can
someone please tell me how to correct it so I don't keep getting error and
blank screen of reminder form.

Private Sub JobNumber_Click()

If (Forms!fttworkloghiddenopen!CboTech) = Forms!fttswitchboard!CboTech And _
IsNull(Forms!fttworkloghiddenopen!StopTime) Then _
DoCmd.OpenForm "fttWorkLogReminder", , , "tech='" &
Forms!fttswitchboard!CboTech & "'"
Else
DoCmd.OpenForm "fGenInfoTT", , , "jobnumber=" & Me!JobNumber
End If
End Sub
__________________________________
If Forms!fttworkloghiddenopen.Recordset.RecordCount > 0 And _
(Forms!fttworkloghiddenopen!CboTech) = Forms!fttswitchboard!CboTech And _
IsNull(Forms!fttworkloghiddenopen!StopTime) Then _
DoCmd.OpenForm "fttWorkLogReminder", , , "tech='" &
Forms!fttswitchboard!CboTech & "'"
Else
DoCmd.OpenForm "fGenInfoTT", , , "jobnumber=" & Me!JobNumber
End If
End Sub

thanks,
Pam



 | 
Pages: 1
Prev: Clicking on Newly Opened Form
Next: text box help needed