Hi Mike,

Have you tried it with and open and close parenthesis in the cUserDepts value?

HTH,
Arriyel

>Hi Guys,
>
>I need some help on figuring out what might be the cause of my remote view problem.
>
>
>Here is the scenario.
>
>I've created a remote view with a (IN) filter condition. Below is a sample code.
>
>[wareitem.whcode IN ?cUserDepts]
>
>the content of cUserDepts is dynamically created based on the departments that were assigned to the user. Below is an example
>'DEP01','DEP02'
>
>If i run the remote view in the remote view designer to extract records, it prompt a window where in you have to specify the value of cUserDepts. I then type 'DEP01','DEP02' as the value and the records are retrieved properly.
>
>The problem occurs once I use the remote view in a form. The records are not being retried when I requery the view. I've checked the value of cUserDepts and it contains the correct value 'DEP01','DEP02'
>
>Any Idea?
>
>Thanks in advance...