URGENT: Opening a Database table

[Shahzad]

Whe I open a recordset I get the following error.

Too few parameters. Expected 1

When I remove the m_strFilter statement ahead of Open(), then i don't get this error. my code is:

GradesSet.m_strFilter ="Grade Like "+ sGrade;
GradesSet.Open();

Can somebody help me!

[CaoJi]

m_strFilter="[field name] LIKE" + sValue

**************************
* Cao Jiling *
**************************

[CaoJi]

What's the field type of Grade?
If it's int or float use >,>=, BETWEEN , etc.

**************************
* Cao Jiling *
**************************

[Shahzad]

rather:

GradesSet.m_strFilter ="[Grades].[Grade] Like " +CString("'") + sGrade + CString("'");

thankx I got the idea!