Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select from ComboBox

Status
Not open for further replies.

YoBi4Ever

Instructor
Jun 5, 2007
17
KW
Hi,
I have a combo box that displays list of names and it works fine. I can type the name and it will showup in the combo box then click on it and I get the data, however, after selecting the name if I press enter, instead of using the mouse, nothing will happens and that name will not be selected! I remember that I was able to use the keyboard then press ENTER to select the namet I want but not it doesn't work.

What am I missing?
Any ideas?

Thank you
 
How are ya YoBi4Ever . . .

Your code should reside in the [blue]After Update[/blue] event instead of the [blue]On Click[/blue] event!

Calvin.gif
See Ya! . . . . . .

Be sure to see FAQ219-2884:
 
Hi AceMan,

My code is in the After Update even! :)
This never happended to me before...


Private Sub ComboSearchID_AfterUpdate()
Me.EmployeeNumber = Me.ComboSearchID.Column(0)
Me.EmployeeName = Me.ComboSearchID.Column(1)
Me.cmdAddTerminatedEmployee.Enabled = True
End Sub
 
YoBi4Ever said:
[blue] . . . however, after selecting the name if I press enter, instead of using the mouse, nothing will happens and that name will not be selected![/blue]
Sounds like corruption. Try deleting and reconstituting the combo . . .

Calvin.gif
See Ya! . . . . . .

Be sure to see FAQ219-2884:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top