Fetch Records from a form using a multiselect
Hi,
Looking to see if anyone can help.
I have Form1 that has a multiselect on it
I have some records in Form 1 that have options added to the multiselect (say a mix of option1, option2, option3, option4 etc)
I have Form2 that has a dropdown populated with option1, option2, option3, option4 etc
When I select an option from the dropdown I would like to get into a collection the records that contain that dropdown selection.
Currently I was trying to work with:
<variable> = <form> [ <field> <opr> <expression> ];
Which doesnt seem to work with a multiselect because the only OPR are less than, more than, equals to etc.
Only seems to be number based, and using contains in there doesnt work either.
Thanks
---
Miles Frankland