Multiple criteria input form

[rplohocky]

After hours of searching, I can't find how to make a multi parameter criteria form. I found info on how to work with dates but not names or numbers.

I want to be able to open a form and have a pop up window ask "Who do you want to research?" and then another window pop up and ask "Which accounts do you want to see?". The user would enter the persons name in the first pop up and then enter multiple account numbers in the second pop up. Then the form with the filtered data will appear in the regular form.

I have one field that has about 20 peoples names. I want to first filter by a name. I have another field with account numbers. I want to be able to type in or select (from a drop down) the account numbers that I want to look at.

Basically I have a bunch of people that manage multiple accounts and want to be able to search their name and then certain accounts that they are in charge of.

If anyone can send me to an example or sample DB I would appreciate it greatly.

 

[isladogs]

Suggest you use 2 combo boxes or listboxes on the main form for this purpose rather than using input boxes. The results should then be used to filter the record source for a subform which is hidden at first and made visible after both items have been selected.

The reason for this approach is that users will have a selection of values to choose from.
The second combo or listbox can itself be filtered depending on the first.

Also, if you use a listbox for the account numbers, it can be multiselect