Filter in Access Data Page

[remdeb648]

Hi,

I am programming a multi-criteria filter in an Access Data Page. I successed to make a simple criteria filter using the code below:

(the code is on a button click action)

MSODSC.DataPages(0).Filter = "Status= '" & SSTATUS.value & "'" 
 
    If MSODSC.DataPages(0).IsFilterOn then
        ' If the filter is on, turn it off.
        MSODSC.DataPages(0).IsFilterOn = false
    else
        ' Otherwise, turn it back on.
        MSODSC.DataPages(0).IsFilterOn = true
    end if
 

Now, I'm trying to make a 2 criteria Filter. I tried the code below but it doesn't work, I get: Type mismatch: '[string: "Status= 'New'"]' when I use the button to filter.

MSODSC.DataPages(0).Filter = "Status= '" & SSTATUS.value & "'" and "Related= '" & SRELATED.value & "'"
 
    If MSODSC.DataPages(0).IsFilterOn then
        ' If the filter is on, turn it off.
        MSODSC.DataPages(0).IsFilterOn = false
    else
        ' Otherwise, turn it back on.
        MSODSC.DataPages(0).IsFilterOn = true
    end if
 

Does someone know why I get this error?

Thanks a lot for your help and if you need more information please let me know.

[remdeb648]

No one have an idea how to solve this problem?

I really need your help...

[jhardman]

is this ASP.NET?

Jared

[remdeb648]

Sorry but I have no idea...