Drop-down list in dialog box

[mare]

I am using Access '97.

I'm working on a new database based on Projects we do in the office. I have created a form that the managers fill out with the basic information regarding that particular project.

Now, there are times when they don't have all the information on hand at once to key it in, so it will be necessary for them to "edit" that project with additional information.

I have created an "Edit" form on a switchboard for this database. When you click the "Edit Project Form", a dialog box pops up, asking to type in the name of the project.

I, personally don't have any problems with this, but the managers, or anyone else who would have to go in and "edit" a project, might not know the "proper" name of the project or worse yet, run into the problem of mistyping the name, at which point they will freak out when nothing appears on the screen.

Problem: is there a way to add a "drop-down" list of projects in the database so that when the user encounters this dialog box, they only have to scroll down and select the appropriate project name and take the user right into the "Edit" form?

Any help on this would be appreciated.

 

[Mile-O]

On your main form, put a combobox listing all projects beside the edit button. It's much easier.