Hi,
I have following Combo lists in my form
Priority: G1, G2, G3
Color: R, G, Y
I have written two functions to get the criteria when a user selects more than one entry at a time.
Like if user selected, Priority as G1, or G2 and Color as R.
then the table should filter out the records as per above criteria.
But when I insert this function in Criteria row, and I run the query it doesn't any records.
To verify the function, I have opened a new form and displaying the returned value in a text and it's works properly but as soon as I insert the function nothing is returned. While If I copy the same criteria returned in text filed in criteria field in Query, it works fine as expected and returns all the values.
Please help me