"Enter Parameter Value"

[ColinSully]

Hello, I have a report that generates a summary of a project for my database. Each project is given a unique project ID. Currently when I go to open the project summary report I am asked for a "Parameter Value" and the enter the project's ID.

What I would like to have happen is that instead of a text box where you have to input an ID number, a drop down list of the projects (ID number and name) is available and the user is asked to pick one.

I don't know how difficult this would be to implement but if anyone has any ideas it would be helpful.

Regards

 

[ColinSully]

apparently I've asked this question before but I still don't know how to solve my problem.

 

[jmersing]

I would create a small form that looks like a parameter value dialog box that has a combobox that shows the number and name of the ID number.

Then after the selections is made use your after update event on the combo to refresh the data on the main form.

Make sure the new form is set to
Modal Yes
and POPup yes
so it is not hidden in the background.