Reseting/selecting value in combo

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

Jonathan Blitz

How can I select a value in a combo from within my code?
Also, how can I reset the combo to having no value selected?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
-----Original Message-----
How can I select a value in a combo from within my code?
Also, how can I reset the combo to having no value selected?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."


.
Click to expand...
Hi Jonathan,

A1 - assign a value that is listed in the bound column of
the combobox. For example bound Column(0) employeeID =
1023 and visible Column(1) Employee = "Eric Idle"

cboEmployeeID.value=1023 will select Eric Idle

A2 - with cboEmployeeID
.value=.itemdata(-1)
End With

Luck
Jonathan
 
Many thanks

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Back
Top