select combobox item by keyborad

[amir0914]

hi all, i make a combo box and i want when i open the list of combo box and press {enter} key from keyboard add item of list to other subform datasheet...is it possible?

 

[arnelgp]

what i would do is add a command button to add it to the subform, therefore i can be clear of the intent.

Private sub button_click()
If me.combo.listindex > -1 then
With me.subformname.form.recordset
.addnew
!fieldname= combo
.update
End with
End sub

 

[amir0914]

Thanks arnelgp, but i don't have button, i want to add with keyboard shortcut from combo box directly.

 

[arnelgp]

I am not in computer right now so i cannot suggest. Just for a test if the code wull work put one button near the combo.