Hello Everyone,
I have an unbound form that pulls up a list of vending machines. The user scrolls through the list of vending machines, or searches using a search box (search as you type), finds the machine(s) they want and then clicks on the button for Run Report. It took a while but I finally have this form working properly.
Because a user cannot look at a machine name and determine if a machine is active or inactive, I want to filter the vending machines in the list box. My thought was that on form load only active vending machines would populate in the list box. Then, if they user needs to see the entire list of machines, they would request to see "all machines" (active and inactive).
Within the query that is populating the form's list box, qryProductSearch, I have a field called InactiveDate. When I manually add "Is Null" to the Criteria only active vending machines are show and when I leave the criteria empty it shows all the machines.
I have tried to use a check box and pass "Is Null" on form load to the query and that's not working. Then I tried to figure out a way to use a combo box with Active and Inactive status and that was a disaster. I have searched Google and the forum and I'm just missing something. I cannot wrap my head around the best way to complete the task at hand. Any help would greatly appreciated because at this point in time I'm drawing a complete blank. Thank you!
I have an unbound form that pulls up a list of vending machines. The user scrolls through the list of vending machines, or searches using a search box (search as you type), finds the machine(s) they want and then clicks on the button for Run Report. It took a while but I finally have this form working properly.
Because a user cannot look at a machine name and determine if a machine is active or inactive, I want to filter the vending machines in the list box. My thought was that on form load only active vending machines would populate in the list box. Then, if they user needs to see the entire list of machines, they would request to see "all machines" (active and inactive).
Within the query that is populating the form's list box, qryProductSearch, I have a field called InactiveDate. When I manually add "Is Null" to the Criteria only active vending machines are show and when I leave the criteria empty it shows all the machines.
I have tried to use a check box and pass "Is Null" on form load to the query and that's not working. Then I tried to figure out a way to use a combo box with Active and Inactive status and that was a disaster. I have searched Google and the forum and I'm just missing something. I cannot wrap my head around the best way to complete the task at hand. Any help would greatly appreciated because at this point in time I'm drawing a complete blank. Thank you!