How to apply filters one at a time on a subform

Follow

Nadia

• July 20, 2022 18:05

I have a form, with filters fields, and a sub form where the result is displayed once the user selects the filters. I use an AutoLookUp control to load the subform.

At this point, the user has to fill in all three comboboxes for the subform to display the results. I would like the subform to update its results as the user selects filter. For example, if you only select the first filter, show the results for that filter only. Is this possible?

 

0

• 

  Varun Agasthya

  • August 02, 2022 12:49

  Nadia,

  To achieve this requirement mentioned and 'OR' operator should be used between each filter conditions in the AutoLookup configuration window. If the AND operator is used, It would depend on all the filter inputs to return the filter result. However, OR operator would return the filter result even with one input. Hope the screenshot(Lookup Configuration Window) can be used as a reference.

  

  0

  Comment actions Permalink

Please sign in to leave a comment.