Search pop-up dialog box for a report

[mare]

I have this really neat database of projects that my department has completed, and now I want to make it very user-friendly so that anyone in the department can use it.

I have a switchboard that lists the different "business channels" in the company (if you click on any one of the bus. channel buttons, you will get a report that lists all the projects for that business, along with other details).

What I would like to do now is on the switchboard, create another option (i.e., "Search for Project"). When you click on the button for this option, a pop-up dialog box appears, asking for name of project. This is will be a quicker way to search for a project than having to go through each business channel looking for it, and something that anyone can do without bothering me.

As not everyone remembers the exact name of the project, I would like to create a "wildcard", so if someone, for example, was looking for a particular project for "fashion", but didn't know what the exact name of the project, they just had to type "fashion" in the dialog box, and a report would be generated that would list all the projects that had "fashion" in its title.

Any help would be appreciated.

 

[RichO]

How about using a parameter query as the record source for your report. The only downside to this is that the wildcard character can't be typed as an option but instead, is always used. But that shouldn't be a problem because if the user knows the full name of the project, they can still type that and additional records will not come up.

Set up your criteria such as....

Like "*" & [Please enter project name] & "*"

Otherwise, another option would be to have a dialog form with a combo box containing all of the project names so no typing would be necessary.

 

[mare]

It works! This is absolutely wonderful! It's doing exactly what I want it to do. Thank you so much!