View Full Version : How to use a combo box to select record sets


kermit5
01-14-2002, 01:21 PM
I would like to have a combo box used on a form to select a record set in stead of entering a value into a field.

For example, when the user opens a form, they select the name of a project in a combo box. When they click on the desired project name, the information for that project is displayed on the screen and the user can then update other information about that project.

How do I set this up?

David R
01-14-2002, 02:19 PM
I believe the combo box wizard will do what you're asking, if I understand your question correctly. When you add an unbound combo box to your form (make sure the Wizards are on), the third option, "Find an existing record.." should guide you through doing what you want.

HTH,
David R