I have an access db with a form on it that is used to search records. One of the fields on this form is a drop-dwon menu with three options, which for the sake of generality we'll call "Option A", "Option B", and "Option C". These options reflect a field in the table that is being searched (each record needs to be one of these options).
I was asked to add an option (call it "Option D") to the search form that would allow users to search for all records that have either "Option A" OR "Option B".
So I tried using this syntax in the query builder.
Like IIf([Forms]![Frm_Name]![Fld_On_Form] = "Option D", "Option A" OR "Option B", [Forms]![Frm_Name]![Fld_On_Form])
This works if the users selects Options A, B, or C from the dropdown, but not D (the true part of the statement). Can anyone tell me why? Or more importantly, how to fix it? Thank you very much in advance.