I have two problems actually, but I'll address them one at a time:
I have a form, as shown below:
When the user selects an item from the menu on the left, the appropriate list is displayed in the area on the right. All working great.
When the Case List is displayed, I give them the option to select filters. I use a pop-up form. See below.
I want the user to make their selections. The SUBMIT procedure builds the WHERE clause and the ORDER BY clause. Appears to be working. See below (not based on image above):
I want the code that displays the filter form to pause and wait for the form to be submitted, and then use the selected filters and sort order to refresh the case list displayed. So I used the code below to display it:
Code:
Case cCaseFilter ' 11 - Show a form of filter criteria in new window model mode
DoCmd.OpenForm "CaseFilter", , , , , acDialog
[Forms]![Main Menu]!subfrmDisplayArea.SourceObject = "CaseList"
But the code does not pause. It keeps right on going.
The filter form is designed as pop-up and modal.
Clearly, I'm not applying something correctly. Any thoughts?
Thanks in advance.