We help IT Professionals succeed at work.
Get Started

Question about Combo Boxes in Microsoft Access

Last Modified: 2013-11-28
I have a form where the user selects a product type from a combo box and what they select is used to narrow down the selection in the opportunity combo box.  Then when they click on create a quote, the data from the opportunity combo box is appended into a table and that record is displayed on a different form.

I would like to give user another option, instead of selecting a value in the product type combo box box they can enter a key number in the opportunity ref no text field.  Once they do that, I would like the opportunity name combo box to automatically populate with that record and the value to be displayed.  

Watch Question
Top Expert 2016
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE