B
Brady Mann - Amatuer Extraordinaire
I have a combobox on an Access 2003 form. The combobox is used by the
user to navigate to a specific record. I want the record number in this
combobox to match the current record. I have done this with one
caveat...the combobox value goes blank after the 8th record (i.e. when
the user moves to record 9 or above, the combobox goes blank). The drop
down list for the combobox still works fine (I can see all the records
past 8) and navigation is unaffected.
Here is the code I'm using to update the value of the combobox. What am
I doing incorrectly?
If IsNull(TBox_OppID.Value) Then
cbo_SelectRecord = Null
ElseIf Nz(cbo_SelectRecord) <> TBox_OppID.Value Then
cbo_SelectRecord = TBox_OppID.Value
End If
user to navigate to a specific record. I want the record number in this
combobox to match the current record. I have done this with one
caveat...the combobox value goes blank after the 8th record (i.e. when
the user moves to record 9 or above, the combobox goes blank). The drop
down list for the combobox still works fine (I can see all the records
past 8) and navigation is unaffected.
Here is the code I'm using to update the value of the combobox. What am
I doing incorrectly?
If IsNull(TBox_OppID.Value) Then
cbo_SelectRecord = Null
ElseIf Nz(cbo_SelectRecord) <> TBox_OppID.Value Then
cbo_SelectRecord = TBox_OppID.Value
End If