combo box with UserDefined function and wrong ...
Posted on 2006-03-23
I have a cmbo box with fnVin in its RowSourceType (nothing in its RowSource) which populates the combo box.
When an item is selected from the dropdown, it shows some other value (from the same field). Why it doesn't display what user selects. For example, when user select 5, it shows 7 or some other number.
Function fncboVin(fld As Control, id As Variant, row As Variant, col As Variant, code As Variant) As Variant
'On Error Resume Next
Dim ReturnVal As Variant
ReturnVal = Null
Select Case code
Case acLBInitialize ' Initialize.
Entries = 0
Entries = Entries + 1
fncboVin = ReturnVal
Code works fine because it populate the combo box ok. Is there some setting