Reseting/selecting value in combo

[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."

 

[Jonathan Parminter]

-----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."


.

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

 

[Jonathan Blitz]

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."