Combo Box, Click to Select?

[GoinDeep]

I have a series of cascading combo boxes used to fill out entries in a form.

Ex: Coat/Shirt/Pant Then Red/Blue/Green/ Then s/m/l Then Product#.

As the user filters through the combo box only (1) Product# is available at the end.

The problem is the user must select "click" the Product# in the combo box to record the value to my table. The users get confused because the product# appears in the box but if they dont click on it it is not recorded.

I would like the Product# field to be automatically recorded. I am using a combo box because, on a few occasions, the user must enter a new product#.

Thanks for any help!

 

[dcx693]

I guess you could attach code to the AfterUpdate property of the Product# combo box so that if there is only one choice returned the record gets saved automatically.

 

[GoinDeep]

Yes, I finally got it working with code using the "ItemData" Thaks.