what will i do if the table has no entry and i will open it..
here's my code
VB Code:
  1. Private Sub MDIForm_Load()
  2. tbAcademicYear.Open "select * from tbacademicyear", cn, adOpenDynamic, adLockOptimistic
  3. If tbAcademicYear.Fields(1) = Null Then
  4.     Exit Sub
  5. Else
  6. Set tbAcademicYear = Nothing
  7. AY = "select * from tbacademicyear where Status like '" & "Open" & "'"
  8. tbAcademicYear.Open AY, cn, adOpenDynamic, adLockOptimistic
  9. StatusBar1.Panels(10) = tbAcademicYear.Fields(0)
  10. End If
  11. end Sub