MS Access – Query Builder Criteria choose NOT NULL input in form

by

I have a form that I want to share where its criteria is based on 2 forms created, if one is null then choose another one.

Thus I have inputted the below criteria, but the “Enter Parameter Value” pop-up still exists:

enter image description here

How I should put the criteria in order to avoid the enter parameter value pop-up everytime? Thanks

  • Instead of using form values directly, use parameter or tempvar.

    – 

  • Are both forms open? Are these forms designed almost identically in arrangement of controls? Could one form serve both purposes? I don’t use parameterized queries. I prefer VBA to build filter criteria and apply to form or report.

    – 




  • At most of the cases only one form will be opened. The forms basically displays the same controls, it is like a form for NEW and a form for EDIT on same table.

    – 

  • If form is not open, you will get prompt. I would make one form serve both purposes. And as already mentioned, not use parameterized query.

    – 




Leave a Comment