combo box selection to auto fill a second combo box (or field)

M

MSA

I have a form that uses two combo boxes "Product" & "Prod_ID". The selection
from combo box Product loads the relevant value in combo box Prod_ID list. So
its working fine, but there is a need that instead of loading the pull dowm
list for the combo box Prod_ID it should fill it, once the selection is made
in combo box Product.

Any advice or suggestion would be much appreciated.

Regards,
MSA
 
J

Jeanette Cunningham

MSA,
I'm not sure I understand correctly.
Here is my guess about what you are wanting to do.
If you wish to set combo box Prod_ID to the top item on its drop down list,
use code like this in the after update event for the first combo:

Me.boxProd_ID = Me.boxProd_ID.ItemData(0)

Jeanette Cunningham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Combo or list box 0
combo box selection 2
Combo Box Menu Selection Problem 0
Combo Box able to select different tables 0
List box selection into combo box 2
Auto Complete and Data Entry in Combo Box 1
combo box 2

Top