Hi All,
I have a table, form, and query in my database. Currently my form options are IM, IR, and Both. The criteria is either IM or IR. I want to be able to filter the table based on the form selection so that if IM is selected, only those results appear, IR for IR, and both IM and IR if Both is selected on the form.
This is the current formula that I have in my query:
Code:
IIf([Forms]![IMDB]![Equipment]="IM","IM",IIf([Forms]![IMDB]![Equipment]="IR","IR",IIf([Forms]![IMDB]![Equipment]="Both",UNSURE WHAT GOES HERE,"")))
It functions correctly when selecting IM or IR individually, but I am not sure how to handle the last part. I know on a regular query I could just do ** In("IR","IM") ** but I am unsure how to handle it in the formula with the form.
Any ideas?
Thanks!