i have a combo box that when an entry is selected it adds its contents as a new record to a table. The problem i have is that if i scroll through the selection using the arrow keys it keeps adding every item the selection is currently on.
is there any way to only execute the code when the selection has been confirmed
i have tried the code on click and change.
the code is
Private Sub cmbAction_Change()
If Not (cmbAction.BoundText = "Select Action" Or cmbAction.BoundText = "") Then
AdodcTodo.Recordset!ID = AdodcCustomers.Recordset!ID
AdodcTodo.Recordset!Date = Date
AdodcTodo.Recordset!Operation = cmbAction.BoundText
AdodcTodo.Recordset!Completed = False
AdodcTodo.Recordset!Time = Now
any ideas thanks