i have this my code
VB Code:
  1. Private Sub MDIForm_Load()
  2. sad = "Select * from tbapplicant where EndDateREserved like '" & lblDate & "%'"
  3.  
  4. tbApplicant.Open sad, cn, adOpenDynamic, adLockOptimistic
  5. With tbApplicant
  6.    ' .Find "EndDateREserved = '" & lblDate & "'"
  7.     If .EOF = False And .BOF = False Then
  8.         Label5 = .Fields(3)
  9.     End If
  10. End With
  11.  
  12. end sub

when i comment the .Find the .fields(3) will display to the label but if i dont comment the .Find no records will display what will i do...

thanks