I've created a form which you can enter one of three different search criteria and OpenReport OnClick event to open a report based on that criteria. Is there a 'where condition' statement that I can use to search my table and bring up the report of the record that contains the data, regardless of which of the three criteria are entered. I am limiting the user to enter only one of the 3 criteria to search and I'd like to avoid using 3 search buttons (one for each criteria).
Thanks!