Combo Box Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that I want to create a combo box so that when I type in the
search criteria and I select enter on the data I want, the fields will
populate with that table's data. For instance, Jane Doe has contributed
money to our agency. I need to find out if she has contributed in the past.
I want to be able to click on the ID code box, key in the first 3 letters of
her code and hit enter if I see it in conjunction with her name. After I do
that, the form will populate with her data in the is in the table.

I have Access 2003.

Please direct me to the answer if this has already been covered in the
Access forum.

Thank you!
 
I have a form that I want to create a combo box so that when I type in the
search criteria and I select enter on the data I want, the fields will
populate with that table's data. For instance, Jane Doe has contributed
money to our agency. I need to find out if she has contributed in the past.
I want to be able to click on the ID code box, key in the first 3 letters of
her code and hit enter if I see it in conjunction with her name. After I do
that, the form will populate with her data in the is in the table.
Click to expand...

Open your Form in design view. Make sure the Toolbox is visible and that the
magic-wand icon is selected. Use the Combo Box tool to add a new combo to the
form. Choose the wizard option "Use this combo to find a record." It'll walk
you through the process.

If the wizard is grumpy, uncooperative, or missing, post back, we can help
too.

John W. Vinson [MVP]
 
Back
Top