I have made a database over my company's investment projects. One of the fields in the investment project table is project manager. When the user registers a new project he or she can choose a project manager from a drop down list. The available project managers come from a table of project managers. I need to create a query that displays all projects for a specific project manager so in the condition box in the design mode of the query, I have written [Choose a project manager]. When you run the query, an inputbox is displayed and you can write the project manager's name in it, and IF you spell correctly, the projects of that project manager is displayed.
However I want the input box to be the same drop down list as I use for registering new project. I.e I want the inputbox [Choose a project manager] to be drop down list NOT a text box where you can write anything.
Does anybody know what to do?
However I want the input box to be the same drop down list as I use for registering new project. I.e I want the inputbox [Choose a project manager] to be drop down list NOT a text box where you can write anything.
Does anybody know what to do?