hey i have this code
VB Code:
  1. If Trs.State = adStateClosed Then

  2.     Trs.Open "SELECT Testble.IDNum, tblMachines.machines_desc FROM Testble, tblMachines", DBConn, adOpenDynamic, adLockOptimistic

  3.     Call Display(0)

  4.     Trs.MoveFirst

and i get an error that says that
"No Value given for one or more of the parameters"

then debugger points to this line
VB Code:
  1. Trs.Open "SELECT Testble.IDNum, tblMachines.machines_desc FROM Testble, tblMachines", DBConn, adOpenDynamic, adLockOptimistic