Remove filter

Hi,

The following code is to filter the records:


datPrimaryRS.Recordset.Filter = "StudentNam = '" & txtYear3 & "'"


Question: How to remove the filter and go back to the normal form.

Thanks.

Try: datPrimaryRS.Recordset.Filter=0

If you still have problems, tell me!

Hi Forest Dragon,

That line of code that you gave me works beautyfully.

Thank you very much.