thanks for reply...
I have John Connell's Beginning VB6 Database Programming but it does not cover too much about Command.  I have had a problem knowing
when to use Command and Recordset.
I had problems setting up Addnew and Update using Recordsets but not with Command.  When I issue a SQL using Command for getting all
rows, setting the recordset to the command,,all is well except if you want to do a MoveFirst or MoveLast,,then you get an error.
Guess I will go back to just using Recordset.