Multiple filters on a continuous form

[Ray67]

Hello



I have a form that show's results from a query. The user picks from a combo box and it displays those records. Now i would like to add more filters to the from. Example Account number, Last name and first name. The user would be able to pick one of these filters and it would display the records.


Thank you

[June7]

Here is one method http://datapigtechnologies.com/flash...tomfilter.html
Also review http://datapigtechnologies.com/flash...earchform.html

[Ray67]

June7

I build the form . I put two unbound text box one for last name and first. In the query criteria i entered this code Like [Forms]![F_RefundRequestCancelCheckForm].[text1] & "*". When i open the form its show all of the records on it. I want the form only to show records if the user enters the patient last name or the first name. If i take of Like &"*" the form doesn't show any records unless i enter the patient name.

[June7]

That will be more complicated with more code to build filter string and apply to form Filter property. Essentially, the form would have to open set with a filter that will not display any records then modify the filter with the combobox choices.