Re: need a correct method to set filter
I am back to this forums. Thank you for all the replies! I used the code from Bob and made some modifications.
Now I need some hints from here to solve my problems. I have a dialog named "menu" consisting two items: client name(combo box); status(check box). If I select a client name and the check box is checked, then click open button, I should see a specific client whose orders were closed in a form(named"ordres). Else If I don't select client name and check box is checked, I will see all the open oreder for all clients; else(don't select client name and leave the check box unchecked), I would see all the records.
I tried several ways to set criteria to the record source under the form, but fail!:(