Search results

Thank you very much for your reply! I'm not required to use the IIf statement. That is just the one that was put there when the database was first created. I just want to make the combo box more agile by allowing it to search both the defendant1name column and the defendant2name column. I see...

I have a combo box search on my main form that is set to search by [defendant1name]. The string code in the query is: LookupName: IIf([defendant1name] Is Not Null,[defendant1name],[defendant2name]) I need the query to search by either [defendant1name] or [defendant2name]. I'm sure this is a...