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

[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

 

[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