Answered: Drop down to open form with specific results
I know this should be easy, but my brain is numb. I have a drop down box containing four (4) choices. Whatever the user chooses then clicks "Search". Another form would open showing the results of that search. My records are of incident reports. The drop down box will contain a choice of 4 different status'. I have a query made for each of the status', but it seems to me I would only need one where the db could read whatever choice was made and then show the results.