Parameter Search Options

[Douglas @ Helpdesk]

I work for a helpdesk and i have been asked to create a database for people
that would like to be on-call in case a agent calls off.

So what i did was i created the querys for the accounts and then changed the
querys into reports. I used "*" [Account Name] "*" so it would pop up a box
so i could type in the account name. That works and it does return what i am
looking for.

Instead of using the parameter search thing, my boss wants to have a drop
down list come up instead that they could select from (will stop users from
typing in the wrong account name). How would i go about doing this and still
have it pop-up to do the search when i click on the report?

I was thinking about having a drop down list, but i dont know how to put it
in place of the search field.

 

[Duane Hookom]

The standard method is to open a form first that contains a combo box. The
user makes a selection from the combo box and then clicks a command button to
open a report.

Parameter prompts aren't good user interface. Controls on forms is much
better.