I'm trying to open a table so that i can assign some values but i can't even set the variable type
refInfo As DAO.recordSet
refInfo.Open "select * from [student information]", _ CurrentProject.Connection, asOpenKeyset, adLockOptimistic
i get a compile error "user-defined type not defined" for the refInfo as DAO.recordset line
1) Why is DAO.recordSet not defined even though i see it in examples?
2) Is this a good way to play with information in tables?
3) Is there any good web site with information on this so that i don't have to bug people with silly 1,2,3 questions?