Error 2427

P

Pam

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Do I need .FindFirst? 0
If And Statement 5
What Am I Missing? 2
Syntax error (missing operator) 4
Repost - Open Form 9
Open form 0
Parameter Value?? 10
Design Help, Please 0

Top