How to apply filters one at a time on a subform

フォローする

Nadia

• 2022年07月20日 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

  • 2022年08月02日 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

  コメントアクション パーマリンク

サインインしてコメントを残してください。