hello please help me on this i am confuse, if i will use this

sql = "select * from item_table where itmno = '" & m_item & "'" 
Set item_rs = con.Execute(sql)

'do i still need to  use this

With cmd

 .ActiveConnection = con
 .CommandText = "item_table"
 .CommandType = adCmdTable
 End With
With mch_rs

  .CursorLocation = adUseClient
  .CursorType = adOpenDynamic
  .LockType = adLockPessimistic
  .Open cmd
End With

hoping for your positive responds...thanks in advance