hi guys this is the code i am using when i run this coode Vb gives me a too few parameter err....these SQL code was genarated in MS Access.. the Group and class and course are all String Varables..i am using Dao 3.6...can anyone find whatz wrong?



SQLString = " SELECT Class_Table.StNo, Class_Table.Group, Class_Table.Course, Class_Table.Class" & _
" From Class_Table" & _
" WHERE (((Class_Table.Group)=" & _
Group & ") AND ((Class_Table.Course)=" & Course & ") AND ((Class_Table.Class)=" & Class & "));"



Set RS = DB.OpenRecordset(SQLString)