Search using Form part of Split Form VS create a separate Search Form - Microsoft Community

hi there, 

i've created split form inventory. there way use form portion search bottom datasheet?  - instead of me having add same fields right next form fields search boxes? @ 1 point played around creating search form never figure out how create button tells datasheet filter based on different fields in search form. 

question 1 - can i/how clear data in form portion of split form in order search different fields (at same time in cascade search effect, not 1 @ time  - thats problem search boxes have - select dropdown box , second make selection search instead of waiting next search input). done through button clears current data form!? if so, macro/code use??

question 2  - if can't clear form data use same fields search, write code button on separate search form tell search each field have entered data into?

question 3 - if cant of above, how make current search boxes search @ same time vs 1 box @ time?

***this split form (i created) within main navigation form.***

i hope makes sense.

thank help!

not use search form feature in sort & filter > advanced section of ribbon?

Office / Access / Microsoft Office Programming / Office 2016