this code for databases is exactly what i was looking for. I understand all of it except the stuff below.


Code:
rsLigue.CursorType = adOpenStatic
rsLigue.CursorLocation = adUseClient
rsLigue.LockType = adLockPessimistic
rsLigue.Source = "Select * From [Ligue]"
rsLigue.ActiveConnection = DB
rsLigue.Open
Also, this is the sql i have coded during design time. Do i need to modify at all. Im just wondering because you use square brackets in your sql statement.
Code:
SELECT  exam_order,objectives,subject FROM Phase1b where exam_order > 0 AND objectives <> " " order by exam_order asc
thanx trin